Recording Dynamic Macros using Relative References
Автор: BrainBell
Загружено: 2025-05-21
Просмотров: 497
In this tutorial, we take a recorded Excel macro and rewrite it into a cleaner, more flexible version using VBA. You'll learn the difference between absolute and relative references in recorded macros, and how to use ActiveCell, Offset, and Resize to create relative references in VBA.
00:00 Recording a Basic Macro to Apply Multiple Formatting
02:39 Recording a Macro to Record Multiple Actions
06:04 Enable "Use Relative References" Option
06:26 Recording a Dynamic Macro using Relative References
09:50 Writing Macros Directly Using VBA
10:58 Explaining Absolute and Relative References in Context of VBA
11:59 Rewriting the Recorded Macro using VBA to Optimize its Code
In this tutorial will help you write smarter macros and understand what's going on behind the scenes.
#excel #vba #macro #ExcelWithBrainBell
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
