I'm trying to automate the following code since I have to do the same thing for PivotTable0 to PivotTableX as well as PivotTable0A to PivotTableXA. Especially since the number of Pivot Tables often changes and I don't want to update (copy paste) the same code for all tables in the sheet.


Please Login or Register  to view this content.
Would be nice to have something like

Please Login or Register  to view this content.
but that gives me an error and as soon as I leave the following line, it adds a space before the brackets:

Please Login or Register  to view this content.
Thanks, Juschk