Excel 2016 Macros

Lesson 2 - Recording Macros

Excel 2016

in the cell to the left of whichever cell is active when you run the macro. Relative references give a macro more flexibility.

The Company macro code



P ROCEDURES

1. Select the desired cell in the worksheet. 2. Click 3. Type the desired macro name. 4. Select the Description box. 5. Type the desired macro description. 6. Select . 7. Click

in the Code group on the Developer tab.

in the Code group on the Developer tab.

8. Perform the steps in the procedure that you want to automate. 9. When you have finished recording macro steps, click

in the

Code group.



S TEP - BY -S TEP Use relative references to record a macro.

If necessary, enable the macros and display the Developer tab.

OFFICEPRO, Inc.

Page 35