Excell Macros Series...3

You can run the macro you have recorded any number of times you want. To run the macro, do the following -

• Click on a new worksheet.

Note the active cell. In our case, it is A1.

• Click the VIEW tab on the Ribbon.

• Click Macros.

• Select View Macros from the dropdown list.

The Macro dialog box appears.

Only the macro that you recorded appears in the Macros list.

• Click the macro name – MyFirstMacro in the Macro dialog box. The description you typed while recording the macro will get displayed. Macro description allows you to identify for what purpose you have recorded the macro.

• Click the Run button. The same table that you have created while recording the macro will appear in just a split of a second.

You have discovered the magic wand that Excel provides you to save time on mundane tasks. You will observe the following –

• Though the active cell before running the macro was A1, the table is placed in the cell B2 as you have recorded.

• In addition, the active cell became E2, as you have clicked that cell before you stopped recording.

You can run the macro in multiple worksheets with different active cells before running the macro and observe the same conditions as given above. Just keep a note of this and you will understand later in this tutorial why it has occurred so.

You can also have a macro recording that places your recorded steps in the active cell.