Excel VBA Notes for Professionals book

Chapters

1. Getting started with excel-vba
2. Debugging and Troubleshooting
3. Methods for Finding the Last Used Row or Column in a Worksheet
4. User Defined Functions (UDFs)
5. VBA Best Practices
6. Loop through all Sheets in Active Workbook
7. Ranges and Cells
8. Common Mistakes
9. Arrays
10. Excel VBA Tips and Tricks
11. PowerPoint Integration Through VBA
12. Workbooks
13. Pivot Tables
14. Binding
15. Charts and Charting
16. Application object
17. Merged Cells / Ranges
18. VBA Security
19. How to record a Macro
20. Locating duplicate values in a range
21. Named Ranges
22. autofilter ; Uses and best practices
23. Creating a drop-down menu in the Active Worksheet with a Combo Box
24. Conditional statements
25. Working with Excel Tables in VBA
26. Excel-VBA Optimization
27. Conditional formatting using VBA
28. File System Object
29. SQL in Excel VBA – Best Practices
30. Use Worksheet object and not Sheet object
31. CustomDocumentProperties in practice