Returns an object that represents either a single PivotTable report (a PivotTable object, Syntax 1) or a collection of all the PivotTable reports (a PivotTables object, Syntax 2) on a worksheet. Read-only.
Syntax 1
expression.PivotTables(Index)
Syntax 2
expression.PivotTables
expression Required. An expression that returns a Worksheet object.
Index Optional Variant. The name or number of the report.