Excel Macro Recorder to VBA Laminated Tip Card

Overview

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 Microsoft’s 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.

Author Biography

Bill Jelen is the host of MrExcel.com and the author of 40 previous books about Microsoft Excel. He has been named a Microsoft MVP for seven years and is a contributor to CFO Magazine and Strategic Finance Magazine. He lives in Akron, Ohio.