PivotTable.RowRange (Excel)

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

Dim rngRowRange As Range
Set rngRowRange = ActiveCell.PivotTable.RowRange