PivotItem.DataRange (Excel)
Returns a Range object as shown in the following table.
Dim rngDataRange As Range
Set rngDataRange = ActiveCell.PivotItem.DataRange
Returns a Range object as shown in the following table.
Dim rngDataRange As Range
Set rngDataRange = ActiveCell.PivotItem.DataRange