I'm trying to record a macro to simplify some data import steps.
I started Record Macro then did all the other stuff. The attached Word doc has the steps, I'm trying to cover steps 3 through 7 with a macro,
I do the steps, it returns the data to the spreadsheet, then gives the attached Macro Error.jpg
If I then go to the macro and say Run (to do it over), it gives the attached Compile Error.
How do I fix it?