_Worksheet.PivotTables Method

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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function PivotTables ( _
    Index As Object _
) As Object
'Usage
Dim instance As _Worksheet
Dim Index As Object
Dim returnValue As Object

returnValue = instance.PivotTables(Index)
Object PivotTables(
    Object Index
)

Parameters

  • Index
    Type: System.Object

    Optional Object. The name or number of the report.

Return Value

Type: System.Object

See Also

Reference

_Worksheet Interface

_Worksheet Members

Microsoft.Office.Interop.Excel Namespace