Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotField Object

Office 2007
Represents a field in a PivotTable report.

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:

Example

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.
Visual Basic for Applications
Worksheets("sheet3").PivotTables(1) _
    .PivotFields("year").Orientation = xlRowField



Community Additions

Show: