Description
A collection of all the PivotTable objects on the specified worksheet.
Accessors
Use the PivotTableWizard method to create a new PivotTable and add it to the collection.
Use the PivotTables method with an argument to access a single member of the collection or without an argument to access the entire collection at once. The following example displays the number of PivotTables on the worksheet named "Sheet3."
MsgBox Worksheets("sheet3").PivotTables.Count
Properties
Application Property, Count Property, Creator Property, Parent Property.
Methods
Item Method.