ColumnRange Property

Applies To

PivotTable object.

Description

Returns a Range object that represents the range that contains the PivotTable column area. Read-only.

See Also

DataBodyRange property, DataLabelRange property, PageRange property, RowRange property.

Example

This example selects the column headers for the PivotTable.

Worksheets("Sheet1").Activate
Range("A3").Select
ActiveCell.PivotTable.ColumnRange.Select