Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Dynamic Ranges/Vbles
|
|
|
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. |
Dynamic Ranges/Vbles
Resolved · Medium Priority · Version 2007
Reply Tue 20 Sep 2011, 16:40Delegate Aurea said...
Aurea has attended:
Excel VBA Intro Intermediate course
Dynamic Ranges/Vbles
Can you please provide an example using dynamic ranges (or the equivalent in VBA - as opposed to actually creating a dynamic range in Excel)?
For upcoming training course dates see: Pricing & availability
RE: Dynamic Ranges/Vbles
Hello Aurea,
In VBA there are numerous ways of writing code to achieve dynamic ranges. Depending on the context of how you want to use a dynamic range it would be difficult to give you an exact answer. If you can provide an excel dynamic range you currently use, and we can provide the VBA equivalent.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Mon 3 Oct 2011: Automatically marked as resolved.
|