Syntax

expression.VisibleFields(Index)

expression A variable that represents a PivotTable object.

Parameters

Name Required/Optional Data Type Description
Index Optional Variant The name or number of the field to be returned (can be an array to specify more than one field).

Remarks

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

Example

This example adds the visible field names to a list on a new worksheet.

Visual Basic for Applications 
Set nwSheet = Worksheets.Add nwSheet.Activate Set pvtTable = Worksheets("Sheet2").Range("A1").PivotTable rw = 0 For Each pvtField In pvtTable.VisibleFields rw = rw + 1 nwSheet.Cells(rw, 1).Value = pvtField.Name Next pvtField
All pivotfields that are not hidden? Get all visible pivot fields? visible visible fields Visible Fields Property VisibleFields VisibleFields Property

See also: