VBA Is there an easy way to recreate new pivot charts

[outlawspeeder]

I building a way for a worker to paste 5k line of info, clean it of $^!$@#$^% and then build a pivot charts (more than one)

I recorded making a Pivot chart. It names the the chart +a number. Mine as recorded is 4. If I use this code again I get an error.
I tried make a variable and replacing the # 4

Var1=format (now,"hhmmss")
It errors out.

sorry about not posting the code but it is on a stand along system.

 

[outlawspeeder]

BUMP