Skip to content

Latest commit

 

History

History
39 lines (24 loc) · 836 Bytes

Excel.PivotTable.ColumnRange.md

File metadata and controls

39 lines (24 loc) · 836 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotTable.ColumnRange property (Excel)
vbaxl10.chm235076
vbaxl10.chm235076
Excel.PivotTable.ColumnRange
7f54b908-b0cb-80c8-e16f-25c7ff536e43
05/08/2019
medium

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

[!includeSupport and feedback]