I've written a macro that creates a pivot table and names it (options).
I have recorded a second macro that references the first pivot table as its source in order to save memory. When I test the second macro in step-through mode, it goes to debug in the second line when referencing the first macro.
I cannot figure out what is causing this. Is it the cache? As I said, I can do these steps manually and it works fine. Let me know if you need additional info or if this is total mud.

Here is the code of the second pivot table macro

Please Login or Register  to view this content.