This book explains the shortcomings of the macro recorder, but also covers how to take the recorded code and turn it into something really useful. Once you are over that hurdle, the book explains how to understand the object-oriented Visual Basic for Applications Language.
1. Unleash the Power of Excel with VBA!
2. This Sound Like BASIC, SoWhy Doesn’t It Look
Familiar?
3. Referring to Ranges
4. User-Defined Functions
5. Looping and Flow Control
6. R1C1 Style Formulas
7. Names
8. Event Programming
9. UserForms-An Introduction
10. Charts
…etc…