PivotField.VisibleItems (Excel)

Returns an pivotitem that represents either a single visible PivotTable item (a PivotItem) or a collection of all the visible items (a PivotItems collection) in the specified field. Read-only.

For OLAP data sources, this property is read-only and always returns True. There are no hidden items.

VisibleItems (Index)

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

Dim pvtiVisibleItems As PivotItem
Set pvtiVisibleItems = ActiveCell.PivotField.VisibleItems