IN THIS CHAPTER
Recording your actions by using the Excel built-in macro recorder
Understanding the types of macros you can record
Setting the appropriate options for macro recording
Evaluating the efficiency of recorded macros
You can use two methods to create an Excel macro:
This chapter deals specifically with the ins and outs of using the Excel macro recorder. Recording a macro isn’t always the best approach, and some macros simply can’t be recorded, no matter how hard you try. You’ll see, however, that the Excel macro recorder is very useful. Even if your recorded macro isn’t quite what you want, the macro recorder can almost always lead you in the right direction.
You take the following basic steps when recording a macro.
Get things set up properly.
This step determines how well your macro works.
Click the Record Macro ...