PivotFields Object (Excel)

A collection of all the PivotField objects in a PivotTable report.


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


Use the PivotFields method of the PivotTable object to return the PivotFields collection. The following example enumerates the field names in the first PivotTable report on Sheet3.

With Worksheets("sheet3").PivotTables(1) 
 For i = 1 To .PivotFields.Count 
 MsgBox .PivotFields(i).Name 
End With

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

See Also


PivotFields Object Members

Excel Object Model Reference