ChildField Property

Applies To

PivotField Object.

Description

Accessor. Returns a PivotField object that represents the child pivot field for the specified field (if the field is grouped and has a child field). Read-only.

Remarks

If the specified field has no child field, this property causes an error.

Example

This example displays the name of the child field for the field named "REGION2."

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
MsgBox "The name of the child field is " & _
    pvtTable.PivotFields("REGION2").ChildField.Name