Runtime error 1004 when running excel macro. Other users do not have same issue with file

I am surprised that you did not get a error message when you developed the "modPaste.Copy" macro. The period should have thrown an error. Try removing the period in both the code and the macro name and see if you still have the problem. The macro name can use underscore and dash to tie the words or simply concatenate them without a space, but periods are edited by the compiler to mean end of statement or expect a valid property.