Topics

• Getting started with excel-vba
• Methods for Finding the Last Used Row or Column in a Worksheet
• VBA Best Practices
• Loop through all Sheets in Active Workbook

Examples

• Find the Last Non-Empty Cell in a Column
• Retrieve all Worksheets Names in Active Workbook
• Find Last Row Using Named Range
• Adding a new Object Library Reference
• Always define and set references to all Workbooks and Sheets