It also displays a miniature floating toolbar, which contains two toolbar buttons: Stop Recording and Relative Reference.ħ. From this point, Excel converts your actions into VBA code. Click OK in the Record Macro dialog box.Įxcel automatically inserts a VBA module.

Each of these items - with the exception of the name - is optional.Ħ. Enter a name, shortcut key, macro location, and description. Excel displays its Record Macro dialog box.ĥ. Determine whether you want cell references in your macro to be relative or absolute.Ĥ. This step determines how well your macro works.ģ. I describe these steps in more detail later in this chapter.ġ. You take the following basic steps when recording a macro. Yes, but you need to do a lot of editing first. Yes, if it’s good (editing usually required). No, it’s just a bunch of magnetic impulses. Rerecord the macro (or edit it if possible). Rerecord the tape (or edit it if possible). Table 6-1 Tape Recording versus Macro RecordingĬhoose ToolsO MacroOMacros (or other methods).ĭepends on the situation and the equipment quality. Table 6-1 compares tape recording with macro recording. Turn it on, do your thing, and then turn it off. Recording a macro is sort of like using a tape recorder.

Even if your recorded macro isn’t quite what you want, the recorder is an excellent learning tool.

You see, however, that the Excel macro recorder is very useful. Recording a macro isn’t always the best approach, and some macros simply can’t be recorded, no matter how hard you try. This chapter deals specifically with the ins and outs of using the Excel macro recorder. Record it using the Excel macro recorder Write it with VBA Recording your actions 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 a macro:

The best macro recorder