PivotTable.PageFields (Excel)

Returns an pivotfield that represents either a single PivotTable field (a PivotField) or a collection of all the fields (a PivotFields collection) that are currently showing as page fields. Read-only.

A hierarchy can contain only one page field. For a PivotTable report based on a PivotTable cache, the collection of PivotTable fields that is returned reflects what's currently in the cache.

PageFields (Index)

Index: The name or number of the field to be returned (can be an array to specify more than one field).


Dim pvtfPageFields As PivotField
Set pvtfPageFields = ActiveCell.PivotTable.PageFields