Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotTable Object

Office 2007
Represents a PivotTable report on a worksheet.

Remarks

The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.

Because PivotTable report programming can be complex, it’s generally easiest to record PivotTable report actions and then revise the recorded code.

Example

Use PivotTables(

index), where index is the PivotTable index number or name, to return a single PivotTable object. The following example makes the field named year a row field in the first PivotTable report on Sheet3.
Visual Basic for Applications
Worksheets("Sheet3").PivotTables(1) _
    .PivotFields("Year").Orientation = xlRowField



Community Additions

Show:
© 2014 Microsoft