PivotTable Object

                  Properties         Methods        

Worksheets collection (Worksheet object)
PivotTables collection (PivotTable object)
CubeField object
CubeFields collection (CubeField object)
Pivot Fields collection (PivotField object)

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.

Using the PivotTable Object

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.

Worksheets("sheet3").PivotTables(1) _
    .PivotFields("year").Orientation = xlRowField

Remarks

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.