PivotField.DisplayAsCaption (Excel)

This property is used to display member properties of PivotFields as captions.

This property returns True when a given member property is used as a caption, and False when a member property PivotField is not used as a caption. Trying to use this property for PivotFields that are not member properties will return a run-time error.

Dim booDisplayAsCaption As Boolean
booDisplayAsCaption = ActiveCell.PivotField.DisplayAsCaption