Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA

Excel VBA

ResolvedVersion 2003

Thu 23 Jun 2011, 16:09 Delegate Ming said...

Ming has attended:
Excel VBA Advanced course

Excel VBA

How to define a range of cells with a specify name range?

Fri 24 Jun 2011, 14:02 Trainer Stephen said...

RE: Excel VBA

Hi Ming

Thanks for the question

Can you clarify your needs for me?

Do you wish to write a procedure that identifies a range and gives it a name?

Thanks

Stephen

Mon 4 Jul 2011, 10:50 Trainer Stephen said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Sun 10 Jul 2011: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Excel VBA

Excel VBA

RE: Excel VBA

Will be marked as resolved in 5 days

Excel articles

Excel tip:

Freeze Rows and Columns to keep lables displayed