Record a macro

Record a macro

To record a macro:

  1. Click Tools > VBA Macros > Record.

  2. Name the macro and continue recording. Note that the macro name can only consist of alphabets, numbers and underscore characters.

  3. Click on the box near Use Relative Reference if you want the cell referencing in the macro to be relative (A1, for instance) and not absolute* ($A$1 for instance).

  4. Make the changes that you wish to be recorded in the macro. 

  5. Click on Stop Recording *image* icon near the notification to stop the process. You can also edit the recorded macro using the VBA editor.


Absolute referencing - The cells are referenced $Column_Number$Cell_Number, meaning the macro is executed in the same cells used when recording the macro.

Relative referencing - The cells are referenced without the "$" constraint, meaning the macro is executed with cells relative from where the macro is executed.

You can choose if you need absolute or relative referencing from the popup indicating that the macro is being recorded too.