Excel macro registration

[sumaiyakhatun26]

Once you're happy with the macro name and (if necessary) keyboard shortcut, select OK to start recording the macro.

Once you start recording your macro, every action you perform (data entry, cell selection, cell formatting, worksheet scrolling, etc.) will be recorded in the new macro as VBA code.

Additionally, as you record your macro, you will see a Stop button at the bottom left of your workbook (or in Excel 2003, the Stop button will be presented on a floating toolbar), as shown below:

Once you have completed the actions you want to record, you can stop recording usa rcs data the macro by clicking the Stop button. The macro code will now be stored in a module in the Visual Basic editor.

'Use relative references' option
If you select the Use Relative References option when recording a macro, all cell references within the macro will be relative. However, if the Use Relative References option is not selected, all cell references displayed in the code will be absolute (see our post on Reference Operators ).

The Use Related References option is found in the Macro menu (and is found on the Macro toolbar in Excel 2003).