Chapters

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

https://cdn.shopify.com/s/files/1/0298/0039/8988/files/ExcelVBANotesForProfessionals.pdf?862