Worksheet.PivotTables(Object) Method

Definition

Gets 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.

public object PivotTables (object Index);
abstract member PivotTables : obj -> obj
Public Function PivotTables (Optional Index As Object) As Object

Parameters

Index
Object

The name or number of the report.

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.

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to