PivotTable.ColumnRange Property

Syntax

expression.ColumnRange

expression A variable that represents a PivotTable object.

Example

This example selects the column headers for the PivotTable report.

Visual Basic for Applications
`Worksheets("Sheet1").Activate Range("A3").Select ActiveCell.PivotTable.ColumnRange.Select`

column range Column Range Property ColumnRange ColumnRange Property Get the range object that represents the pivottable column area?

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