Topics

• Getting started with excel-vba
• Debugging and Troubleshooting
• Methods for Finding the Last Used Row or Column in a Worksheet
• VBA Best Practices
• Excel VBA Tips and Tricks
• PowerPoint Integration Through VBA

Examples

• Declaring Variables
• Opening the Visual Basic Editor (VBE)
• Find the Last Non-Empty Cell in a Column
• ALWAYS Use "Option Explicit"
• Error Handling
• Immediate Window
• Using xlVeryHidden Sheets
• The Basics: Launching PowerPoint from VBA
• Using Strings with Delimiters in Place of Dynamic Arrays
• Double Click Event for Excel Shapes