Chapter 6
Using the Excel Macro Recorder
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
You can use two methods to create an Excel macro:
Record it by using the Excel macro recorder.
Write it manually.
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.
Is It Live, or Is It VBA?
In previous editions of this book, I compared recording a macro to using a tape recorder. However, it occurred to me that tape recorders are rapidly going the way of the dinosaurs. So I modernized this section, and it now ...
Get Excel VBA Programming For Dummies, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
