Name Sheet for a pivot Table

Hy!
I need some help a with this macro.
This code is creating successfully a pivot table in a sheet called "SheetY" where Y is the next number available for sheets .
Can anyone tell me how can i pinpoint a fixed destination for the pivottable (eg : "new_sheet").
Running the macro several times will create Sheet4,5,6,7,8 etc.

Please Login or Register  to view this content.

Have a nice day !

I have found a solution, and that is to add before end sub()

Please Login or Register  to view this content.

Please take a few minutes to read the forum rules (link in menu bar), and then edit both of your posts to add code tags.