Expand Minimize

PivotTable.RowRange Property (Excel)

Returns a Range object that represents the range including the row area on the PivotTable report. Read-only.

expression .RowRange

expression A variable that represents a PivotTable object.

This example selects the row headers on the PivotTable report.

Worksheets("Sheet1").Activate 
Range("A3").Select 
ActiveCell.PivotTable.RowRange.Select
Show:
© 2014 Microsoft