cvincent
Board Regular
- Joined
- Aug 28, 2011
- Messages
- 66
I have a very large file, with data in cells A12:AB12000, identified as a named range. The file contains many macros, and is used by multiple employees. Employees update the file daily, and utilize macros to sort by various columns using a macro button at the top of each column. All sorts are done utilizing the named range. At the end of the week they click a button to "submit" their file.
When they click the "submit" button, the macro saves the file to their computer, then sorts the data using a named data range, and saves the file with a password to a special report folder. All the macros work fine on my pc, but some employees keep getting error messages everytime a sort function is used in a macro. They receive an error message 1004, "Method Goto of object Application failed". If I change the named range in the macro to a range reference, the macros once again work fine.
This is wonderful when it works, but need to find out why this happening for some people and not others using the same file? Some are able to use the file with no problem for 1 or 2 weeks, then come the 3rd week, and they get the error message.
Thank you.
When they click the "submit" button, the macro saves the file to their computer, then sorts the data using a named data range, and saves the file with a password to a special report folder. All the macros work fine on my pc, but some employees keep getting error messages everytime a sort function is used in a macro. They receive an error message 1004, "Method Goto of object Application failed". If I change the named range in the macro to a range reference, the macros once again work fine.
This is wonderful when it works, but need to find out why this happening for some people and not others using the same file? Some are able to use the file with no problem for 1 or 2 weeks, then come the 3rd week, and they get the error message.
Thank you.