PivotField.Caption (Excel)

Returns a String value that represents the label text for the pivot field.

The following table shows example values of the Caption property and related properties, given an OLAP data source with the unique name "[Europe].[France].[Paris]" and a non-OLAP data source with the item name "Paris".

ActiveCell.PivotField.Caption =