Hi,
I've recorded adding one pivot table and then copying it 4 times and changing some info.
The code below remembers the old Pivot Table no 11. How do I get it to use the next un-used Pivot table no ??
ActiveSheet.PivotTables("PivotTable11").PivotFields("Source").CurrentPage = _
"P. YR"
Any help appreciated
VBA Noob
Bookmarks