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 to executing, you can choose the starting cell to be any other cell on the sheet.
In this chapter, we will cover the following recipes:
- Setting the macro recorder for absolute or relative reference
- Recording options