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