How To Reference Ranges In Excel VBA - Part 2

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 FIRST*
https://youtu.be/8wrklExhD_s

In part 1, 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 (this video), 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 (I use at home) but also applies to Microsoft 365 (I use in the office)
* You cannot run VBA/Macros directly in Excel online

*Excel Tips Playlist*
https://www.youtube.com/playlist?list=PL8zztIrMXMC7H595kmYDJF_yFE0JNk2OW

Видео How To Reference Ranges In Excel VBA - Part 2 канала XLWizardry