Show details of pivot table in the same worksheet

[jaryszek]

Hi Guys,

My code is simple and it is showing details of my pivot table:

Please Login or Register  to view this content.

The problem is that these details are showed in other, automatically created by Excel worksheet.
It is possible to have details in the same worksheet as pivot table ?

Any advices are welcome,
Best regards,
Jacek Antek

[noboffinme]

Hi jaryszek,

I think the reason a new worksheet is used is because it's easier to paste into Cell A1 somewhere rather than paste over your pivot or source data.

Instead of your 'With Statement' could you hold the range named as a variable & give it a Cell.Range to paste into on your original worksheet?