Overview of the VBA Editor, Reading VBA Code, and Eliminating Waste

First, a quick overview of how to record and run macros. Then the tutorial shows the user how to manually check the VBA code for a particular macro. How to change module names and macro names. Also a few key terms such as Integrated Development Environment (IDE).

A few key takeaways form this tutorial.

1. Open the VBA Editor

2. Rename Modules

3. Edit Modules and Sub/End Sub

4. How to add comments to the code

5. How to read the code - sort of

6. How to auto-fit columns using VBA

7. Saving macro enabled workbooks