This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This bo

Table of Contents:
1. Unleash the Power of Excel with VBA 2. This Sounds Like BASIC, So Why Doesn’t It Look Familiar? 3. Referring to Ranges 4. User-Defined Functions 5. Looping and Flow Control 6. R1C1-Style Formulas 7. What’s New in Excel 2007 and What's Changed 8. Create