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.