Chapter 6
Using the Excel Macro Recorder
IN THIS CHAPTER
Recording your actions by using the Excel built-in macro recorder
Recognizing the types of macros you can record
Setting the appropriate options for macro recording
Evaluating the efficiency of recorded macros
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 see, however, that the Excel macro recorder is extremely useful. Even if your recorded macro isn’t quite what you want, the macro recorder can almost always lead you in the right direction.
Recording Basics
You take the following basic steps when recording a macro:
- Determine what you want the macro to do.
Set things up properly.
This step determines how well your macro works.
- Determine whether you want cell references in your macro to be relative or absolute (see “Choosing Between Relative Mode and Absolute Mode” later in this chapter).
Click the Record Macro button on the left side of the status bar (or ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access