Home / MS-Excel / General Formatting

Excel Relative or Absolute Macro

When recording your actions, Excel normally records absolute references to cells. (This is the default recording mode.)

Very often, this is the wrong recording mode. If you use relative recording, Excel records relative references to cells.

The distinction is explained in this tutorial.

Following these sections:

  • Recording Absolute Macro
  • Recording Relative Macro

In this tutorial:

  1. Recording Absolute Macro
  2. Recording Relative Macro