| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get the name of the Pivot Table using Macros
I am copying a Pivot Table and pasting it within the same sheet using a
Macro. However when i try to modify the properties of the newly pasted pivot table, i am thrown a error which says that the Pivot table does not exist. The Table properties on the copied pivot diaplay the name of the Pivot to be "PivotTable12" but depending on how many times i have run this macro without closing XL this # can vary. What i want to do from within the Macro is to know of the name of the Pivot Table so that i can refer to it when making the changes to the settings. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Threaded Mode
