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.
Was this article helpful?