PivotField.MemberPropertyCaption (Excel)

Setting the MemberPropertyCaption property controls which member property is used as a caption for a given level.

This setting has a visual effect only when UseMemberPropertyAsCaption is set to True for the PivotField. When MemberPropertyCaption is set, the setting is remembered while toggling the UseMemberPropertyAsCaption property.

ActiveCell.PivotField.MemberPropertyCaption =