Changing Pivot Table Destination

[kidengineer]

This should be an easy one I suppose.

I simply cannot remember how to do it whilst I've searched all over, perhaps I was searching at the wrong place. Would really appreciate if someone could lend a hand on this one.

I am trying to change the following. Based on the code, currently it says Tabledestination:=Range("A1") which means it would create a pivot table on the same sheet at cell A1. I'd like it to create on a separate sheet titled NewSheet on cell A1

Please Login or Register  to view this content.

Thanks in advance!

[judgeh59]

have you tried

Please Login or Register  to view this content.

untested