Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Excel VBA

ResolvedVersion 2003

Fri 6 Jun 2008, 16:01 Delegate Carl said...

Carl has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course
Excel VBA Intro Intermediate course
Project Intro Intermediate course

Excel VBA

Is it possible to refer to a named range of cells (on a worksheet) in a VBA code module? What syntax should be used?

Sun 8 Jun 2008, 16:19 Trainer Katie said...

RE: Use range name in Excel VBA

Hi Carl,

Thank you for your question. I hope you have enjoyed the training. Regarding to your question, you can always use a range name instead of cell addresses in VBA code.

For instance, if the cell range A1 to A10 is named as

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel VBA

Excel VBA

RE: Use range name in Excel VBA

Excel articles

Excel tip:

Paste with Live Preview in Excel 2010