Preparing to Record

Before you take the big step and turn on the macro recorder, spend a minute or two thinking about what you're going to do. You record a macro so that Excel can automatically repeat the actions you record.

Ultimately, the success of a recorded macro depends on five factors:

1 How the workbook is set up while you record the macro 1 What is selected when you start recording 1 Whether you use absolute or relative recording mode 1 The accuracy of your recorded actions 1 The context in which you play back the recorded macro

The importance of these factors becomes crystal clear when I walk you through an example.

0 0

Post a comment