Excel 2007 VBA macro programming

Part I. Programming in Excel VBA
 Ch. 1. The Basics
 Ch. 2. Variables, Arrays, Constants, and Data Types
 Ch. 3. Modules, Functions, and Subroutines
 Ch. 4. Programming Basics: Decisions and Looping
 Ch. 5. Strings and Functions and Message Boxes
 Ch. 6. Operators
 Ch. 7. Debugging
 Ch. 8. Errors and the Error Function
 Ch. 9. Dialogs
 Ch. 10. Common Dialog Control
 Ch. 11. Command Bars and Buttons
 Part II. Object Models
 Ch. 12. The Excel Object Model
 Ch. 13. The Excel Object Model--Main Objects
 Ch. 14. Using Excel to Interact with Other Office Programs
 Ch. Part III. Advanced Techniques in Excel VBA
 Ch. 15. Charts and Graphs
 Ch. 16. Working with Databases
 Ch. 17. API Calls
 Ch. 18. Class Modules
 Ch. 19. Animation
 Ch. 20. Working with XML Files
 Ch. 21. The Ribbon
 Ch. 22. Pivot Tables
 Part IV. VBA in Action
 Ch. 23. Converting Labels to Numbers and Numbers to Labels
 Ch. 24. Transposing a Range of Cells
 Ch. 25. Adding Formula Details into Comments
 Ch. 26. Calculating a Range
 Ch. 27. Reversing a Label
 Ch. 28. Who Created the Workbook
 Ch. 29. Evaluating a Cell
 Ch. 30. Sorting Worksheets into Alphabetical Order
 Ch. 31. Replacing Characters in a String
 Ch. 32. Timed Events
 Ch. 33. Auto-Totaling a Matrix of Numbers
 Ch. 34. Absolute and Relative Formulas
 Ch. 35. Coloring Alternate Rows and Columns of the Spreadsheet
 Ch. 36. Coloring Cells Containing Formulas
 Ch. 37. Summing Cells by Reference to a Master Cell
 Ch. 38. Globally Changing a Range of Values
 Ch. 39. Displaying Hidden Sheets Without a Password
 Ch. 40. Searching Multiple Sheets and Workbooks
 Ch. 41. Brighten Up Your Comments
 Ch. 42. Importing a CSV File Containing Leading Zeros
 Ch. 43. Working with Shapes
 Ch. 44. Turning Your VBA Code into a Add-In
 Appendix. ASCII Character Codes
 Index