PivotField.ChildField (Excel)

Returns a PivotField object that represents the child field for the specified field (if the field is grouped and has a child field).

If the specified field has no child field, this property causes an error. This property is not available for OLAP data sources.

Dim pvtfChildField As PivotField
Set pvtfChildField = ActiveCell.PivotField.ChildField