Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key VBA programming techniques for Excel macros, including:

* Working with the Visual Basic Editor
* Using the Excel Object Model
* Utilizing variables and arrays
* Harnessing built-in functions
* Debugging macros
* Defining ranges
* Manipulating cells
* Customizing dialog boxes
* Working with charts
* Automating procedures

Extra Apply It

* "Apply It" and "Extra" sidebars highlight useful tips
* High-resolution screen shots demonstrate each task
* Succinct explanations walk you through step by step
* Two-page lessons break big topics into bite-sized modules