Edit

Share via

PivotField.ChildField property (Excel)

  • Article

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

Syntax

expression.ChildField

expression A variable that represents a PivotField object.

Remarks

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

This property is not available for OLAP data sources.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.