Use the same macro on multiple pivots

Hi all, I found the macro below in the following post: http://www.excelforum.com/excel-prog...ml#post3744592.

Is there a way for me to use the same code for multiple pivot tables (not all) which are on the same sheet?

Please Login or Register  to view this content.

Thank you.

Regards,
Tejal

Hi, thanks for replying. I keep getting msgbox error: PT choice error when I type in "1 to 10". Am I doing something wrong?