Topics

• VBA Best Practices
• Workbooks
• Pivot Tables

Examples

• ALWAYS Use "Option Explicit"
• Use descriptive variable naming
• Never Assume The Worksheet
• Avoid using SELECT or ACTIVATE
• Application Workbooks
• When To Use ActiveWorkbook and ThisWorkbook
• Opening A (New) Workbook, Even If It's Already Open
• Saving A Workbook Without Asking The User
• Changing The Default Number of Worksheets In A New Workbook
• Creating a Pivot Table
• Pivot Table Ranges
• Adding Fields to a Pivot Table
• Formatting the Pivot Table Data