How To Reference Ranges In Excel VBA - Part 2
Автор: XLWizardry
Загружено: 2025-10-22
Просмотров: 72
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
