If you use absolute recording mode, Excel records actual cell references.

If you use relative recording, Excel records relative references to cells.

A macro recorded by using absolute references always produces the same results when it is executed.

In this case, the macro always enters the names of the first three months in the range B1:D1 on the active worksheet.

You may want the macro to start entering the month names in the active cell.

When the button appears normally, you are recording in absolute mode.

In this example, you activate the beginning cell before you start recording.

This is an important step when you record macros that use the active cell as a base.

The month names are always entered beginning at the active cell.

The month names are entered in three cells, beginning with the cell that you activated.

This may seem strange because you never used cell A1 during the recording of the macro.

This is simply a byproduct of the way the macro recorder works.

He has been named a Microsoft MVP for his ongoing contributions to the Excel community.

Relative Addressing Excel Macro Recording For Mac