Description
The card explains that the Macro Recorder in Excel has been known to have problems in the past, and provides instructions on how to change three settings in order to make the recorder work better. The card also provides instructions on how to create a VBA code block that can be added to a recorded macro to make it more useful.
When using Excel, people frequently run into repetitive tasks that they have to repeat countless times. The proper technique is to use a macro written in the Visual Basic for Applications (VBA) language; yet Microsofts Macro Recorder in Excel has suffered from the same fatal flaws for the last 20 years. The front of this card will teach users how to change three settings in Excel that allow the macro recorder to actually work. The back of the card will dive into the VBA language, teaching the reader five bits of code that they can add to their recorded macro to provide truly useful macros.