PivotTable.VisibleFields (Excel)

Returns an pivotfield that represents either a single field in a PivotTable report (a PivotField ) or a collection of all the visible fields (a PivotFields collection). Visible fields are shown as row, column, page or data fields. Read-only.

For OLAP data sources, there are no hidden fields, and this property returns all the fields in the PivotTable cache.

VisibleFields (Index)

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

Dim pfsVisibleFields As PivotFields
Set pfsVisibleFields = ActiveCell.PivotTable.VisibleFields