PivotTable Interface
Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00020872-0000-0000-C000-000000000046")> _
Public Interface PivotTable
'Usage
Dim instance As PivotTable
[InterfaceTypeAttribute()]
[GuidAttribute("00020872-0000-0000-C000-000000000046")]
public interface PivotTable
Remarks
Use PivotTables(index), where index is the PivotTable index number or name, to return a single PivotTable object.
Because PivotTable report programming can be complex, it’s generally easiest to record PivotTable report actions and then revise the recorded code. To record a macro, point to Macro on the Tools menu and then click Record New Macro.