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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy