Forum Discussion
WayneEK
Nov 25, 2019Copper Contributor
Macro Error for Pivot Table
I can create a Pivot Table for the data I download and it works fine. However, when I made a Macro to do the same thing, I get an error. The error is: Run-time error '5': The following is a scre...
Smitty Smith
Microsoft
Nov 25, 2019WayneEK Does "Table1" exist? And what about the destination "Contract1 Report"?
If either one of those doesn't exist, or is even spelled differently, then that would cause the code to bug.
WayneEK
Nov 25, 2019Copper Contributor
Thanks for replying. I confirmed the spelling and reference to the sheet and table is correct but am still getting the error. The only thing I can think it might be is that I should create a separate Sheet to put the Pivot Table on, instead of the existing sheet that the table is on. Thanks anyways.