PivotTable.ColumnRange Property (Excel)

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

Syntax

expression. ColumnRange

expression A variable that represents a PivotTable object.

Example

This example selects the column headers for the PivotTable report.

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

See also

PivotTable Object