Moving Macro Error 400

[Amber12]

I have a Macro saved in the personal workbook. If I cut and paste it in an workbook is not working and it gives me the “400” error. I don’t want to redo the macro and I have other such macros to copy in other spreadsheets. How can I do this without ending with an error?

[gmr4evr1]

That is going to be difficult to answer without seeing the code, or the workbooks you are using. Maybe one of the following is the issue:
Pasted to wrong module type, I.E from Sheet to Workbook or vise versa.
Sheet names will wreak havoc too....if they are different from one workbook to the other.
Check for hidden sheets.
Again, doing this with a blind eye here so these suggestions may not help at all.