How To Reference Ranges In Excel VBA - Part 2

Описание: In most cases, whenever you do an insert/delete/move in Excel, affected formulas automatically adjust so that references reflect the changes made. With VBA/macros however, these need to be manually changed depending on how they have been referenced. In a two part video I talk about ways to avoid or at least minimise changes required.

In part 2, I focus on making start and last rows dynamic so no macro changes are required when the number of rows change.

Part 1
   • How To Reference Ranges In Excel VBA - Part 1  

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
   • EXCEL TIPS