PivotField.ChildField Property

  • Article
Excel Developer Reference

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."

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

See Also