Excel.PivotField.ChildField.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotField.ChildField property (Excel)	vbaxl10.chm240075	vbaxl10.chm240075	Excel.PivotField.ChildField	97e246de-208f-5932-a553-525da17b0d4d	05/04/2019	medium

PivotField.ChildField property (Excel)

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

[!includeSupport and feedback]