Worksheet.PivotTables Method (Excel)
Returns an object that represents either a single PivotTable report (a PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet. Read-only.
Syntax
expression .PivotTables(Index)
expression A variable that represents a Worksheet object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Index |
Optional |
Variant |
The name or number of the report. |
Return Value
Object
Example
This example sets the Sum of 1994 field in the first PivotTable report on the active sheet to use the SUM function.
ActiveSheet.PivotTables("PivotTable1"). _
PivotFields("Sum of 1994").Function = xlSum