Hello All,
I recorded a macro to insert a pivot table on a Sheet "LEAS Pivot" within the same workbook as my data (Sheet "Data"). I finished the recording, saved the macro and Excel workbook, then deleted the newly created pivot table (deleted everything on the sheet, no residual left) and ran the recorded macro only to receive "Run-time error '5': Invalid procedure call or argument" for the following:
I'm in Excel 2010 with a brand new macro-enabled file and have successfully used this coding in multiple other macros. I did not edit anything within the macro between creation and re-run. Other macros in other files work just fine. A simple "hello world" macro in the troublesome workbook also works just fine. Please advise on what I'm doing wrong.Please Login or Register to view this content.
Many thanks.
Bjordion
Bookmarks