Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to rename a GROUP in a Pivot table | Charts and Charting in Excel | |||
rename groups in Pivot table | Excel Discussion (Misc queries) | |||
Rename a worksheet to use with a pivot table | Excel Programming | |||
REname Pivot table columns | Excel Programming | |||
Using VBA to rename Pivot Table Query | Excel Programming |