Can someone help me make this where the name of the pivot table does not matter?

[taylorsm]

Can someone help me make this where the name of the pivottable does not matter? The name changes and breaks the macro if you delete a pivot and want to rerun the macro. For example. You create PT1, PT2, PT3, then you delete PT2 & PT3, and create two more PTs. Those are PT4 & PT5. So the macro would not work the second time because new PT will have the wrong names

The clearcache seems to work, but then it screws up on setting the pivot fields. "Unable to get the pivotfields property of the pivottable class."

Please Login or Register  to view this content.

[taylorsm]

Think I got it! Still ugly and probably 100 ways to do it better but nonetheless it appears to be working.

Please Login or Register  to view this content.

[taylorsm]

Think I got it! Still ugly and probably 100 ways to do it better but nonetheless it appears to be working.

Please Login or Register  to view this content.