The macro recorder is a handy tool that records what you do in Excel. This tutorial will guide you through the process of recording a macro.
Before we begin, it’s important to point out the macro recorder isn’t perfect. It can’t record everything you do in Excel. For instance, if you use the “Text Import Wizard” to paste a block of text in fixed width format, the macro recorder fails. It will capture the paste, but it won’t record the desired format. There are ways around this, but that’s for a future lesson.
Now that you understand the limitations, let’s begin.
The cells in range “D1:F4” of Sheet2 will turn yellow.
You now know how to start recording a macro, stop recording a macro and play your recorded macros. In addition, you learned the Excel Macro Recorder is not perfect and I introduced you to one such limitation. You are well on your way to becoming a VBA expert.