PivotTable.CompactLayoutColumnHeader Property

Excel Developer Reference

Specifies the caption that is displayed in the column header of a PivotTable when in compact row layout form. Read/write String.

Version Information
 Version Added:  Excel 2007

Syntax

expression.CompactLayoutColumnHeader

expression   A variable that represents a PivotTable object.

Remarks
When the user customizes these captions in the grid, it is also reflected in these properties.

See Also