How To Reference Ranges In Excel VBA - Part 1
Whenever you insert/delete/move in Excel, corresponding references in your macros may need to be manually changed. Today I discuss different methods to avoid or at least minimise changes required.
Watch Next
• How To Reference Ranges In Excel VBA - Part 2
About
In part 1 (this video), I focus on moving hardcoded references out of the embedded code and into a central module making it easier to find and change references when needed.
In part 2, I focus on making start and last rows dynamic so no macro changes are required when the number of rows change.
Excel Version
Recorded using Excel Pro Plus 2021 but also works with Microsoft 365
You cannot run VBA/Macros directly in Excel online
Excel Tips Playlist
• EXCEL TIPS