PivotTable Object

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(), where is the PivotTable index number or name, to return a single PivotTableobject. 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

See also:

• Excel Object Model Reference
• PivotTable Object Members
• PivotCache Object
• PivotCell Object
• PivotField Object
• PivotFormula Object
• PivotItem Object
• PivotItemList Object
• PivotLayout Object