Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Naming Cell Ranges

Resolved · Medium Priority · Version 2007

Reply Thu 5 Feb 2009, 16:58Delegate Oliver said...

Oliver has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Naming Cell Ranges

How is it possible to dynamically name a range of cells?

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Apr 2009, 15:36Trainer Stephen said...

RE: Naming Cell Ranges

Hi Oliver

thank you for your question

First let me apologise for the delay in responding to your post

The following code programatically creates a name for a range of cells

Sub RangeName() Dim rngRange As Range Set rngRange = Range("a1:d42") rngRange.Name = "Test" End Sub

i hope this is useful

Regards

Stephen

Fri 24 Apr 2009: Automatically marked as resolved.

Excel articles

· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Correcting Numerical Glitches In Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· Share And Share Alike - Use Excel To Collaborate As A Winning Team!
· A Brief Glimpse At Excel's What If Analyses Tools

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

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