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

*The digital edition does not include access codes to additional material or programs mentioned in the book.