RowRange Property
Returns a Range object that represents the range including the row area on the PivotTable report. Read-only.
This example selects the row headers on the PivotTable report.
Worksheets("Sheet1").Activate
Range("A3").Select
ActiveCell.PivotTable.RowRange.Select