Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel VBA
Resolved · Low Priority · Version 2003
Reply Fri 6 Jun 2008, 16:01Delegate 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?
For upcoming training course dates see: Pricing & availability
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
|