Duration
1 days
Lesson 1: Working with the PivotTable Object
- Understanding PivotTables
- Creating a PivotTable Using Worksheet Data
- Working with PivotTable Objects
- Working with PivotFields Collection
- Assigning a Macro to the Quick Access Toolbar
Lesson 2: Debugging Code
- Understanding Errors
- Using the Debugging Tools
- Setting Breakpoints
- Stepping through Code
- Using Break Mode during Run mode
- Determining the Value of Expressions
Lesson 3: Handling Errors
- Understanding Error Handling
- Understanding VBA’s Error Trapping Options
- Trapping Errors with the On Error Statement
- Understanding the Err Object
- Writing an Error-Handling Routine
- Working with Inline Error Handling
Programme scope, delivery arrangements and suitability are confirmed during enquiry.