Return Row of DataCell in PivotTable

[wratul]

ShowDetail property generates a new detail worksheet. I want to iterate through each cell in DataBodyRange and only return the row number of the underlying source. How would I do that?

Thanks,