PivotTables Method

See Also         Example         Applies To

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.