I am trying to step through a macro, created using the recorder, that builds a pivot table based on another pivot table. When I use the step-through in the VB screen to test the macro, it goes straight to debug in the first set of instructions. The error message is "Run-time error 1004" Application-defined or object-defined error.

Please Login or Register  to view this content.
I've tried changing "PivotTable2" to "ControlTotals" knowing that each time I try and build the pivot table in testing it will increment by 1. No luck.

I've searched through the archives and googled tyring to find a resolution but so far have come up empty.
Any help would be apprecitated or point me to a potential resource.

Below is the complete code to build the macro, and yes I know it needs to be cleaned up. I just need to get past this first hurdle.
Please Login or Register  to view this content.
Thanks.