Pivot table rename
 

hi guys

after running a macro through a pivot table a few times i found that the
data inside became corrupt. so to save time i created the same pivot next to
it. once ive ran the macro a few times i copy and paste the backup over the
origional and manually change the name of the pivot table. this works
brilliantly so no issues there.

i am however trying to macro this process. but am coming up against what
could be a simple thing. how do i get the new pivots name. the range for the
pivot is ad4:Ag9. the reason for the name is that all my macros run using the
pivots actual name and when copying and pasting over it reverts to a new name
and it keeps changing the more i do it.

ive tried
range("AD4").select
active.pivottables.name="UM"
selection.pivottable.name="UM"

please help

rivers