VBA PivotTable ShowDetail writing into array

[Anton1408]

Hello everyone,

I have a PivotTable with 5 thousand rows. For each row, I need to know their detailed positions. I can use the ShowDetail method, but it's not exactly what I want. It's created a new sheet for each row.
Is there a way to extract details of a row into a variable without creating new sheets?

Thanks!