PivotField Object

Remarks

The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.

In some cases, it may be easier to use one of the properties that returns a subset of the PivotTable fields. The following properties are available:

• ColumnFields property
• DataFields property
• HiddenFields property
• PageFields property
• RowFields property
• VisibleFields property

Example

Use PivotFields(), where is the field name or index number, to return a single PivotFieldobject. The following example makes the Year field a row field in the first PivotTable report on Sheet3.

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

See also:

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