Recording macros that use relative or absolute cell references
By default, addresses in macro commands use absolute cell addressing like A1 and C6. You can record absolute cell references. However, you can also record macro commands that use relative references so you can play the macro in different parts of a notebook or in different notebooks. For more information on absolute and relative cell addresses, see “Absolute and relative cell addresses.”
To record macros that use relative or absolute cell references |  |
|
1.
|
|
Click Tools
 Macro Options. |
|
2.
|
|
Enable one of the following options:
|
|
•
|
Relative
|
|
•
|
Absolute
|