PivotField.PropertyParentField (Excel)

Returns a PivotField object representing the field to which the properties in this field pertain.

Valid only for fields that are member property fields. If the IsMemberProperty property is False, using the PropertyParentField property returns a run-time error.

Dim pvtfPropertyParentField As PivotField
Set pvtfPropertyParentField = ActiveCell.PivotField.PropertyParentField