PivotField Object [Excel 2003 VBA Language Reference]
Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.
Using the PivotField Object
Use PivotFields(index), where index is the field name or index number, to return a single PivotField object. 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
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