VBA Automation for Excel 2019 Cookbook

Chapter 5: Next Level Recording

Doing a basic recording is simple. There is, however, more to recording a macro than meets the eye. Planning plays a role, and so does relativity. Understanding and using absolute or relative references when recording a macro can make or break your procedure. It is also useful to understand that macro recordings are limited to direct actions taken in a worksheet. Functions, IF statements, loops, and custom dialog boxes, to name a few, cannot be recorded.

Relative referencing in macros opens up a new world of functionality. Most importantly, it allows you to run a macro on specific, chosen cells, instead of being limited to one location. You can, in other words, record a macro starting in cell A1, but when it comes ...