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