Run-Time Error 1004 - Urgent Help !!

[Jamie2002]

I need help urgently, this morning I was playing around trying to get a spreadsheet to change scenarios by way of a command button and kept getting a 1004 run-time error.

Now I've come to do my real work and macros that do data sorts and format and back-up my spreadsheets are all failing with the 1004 run-time error with messages such as;

Copy Method of Range Class Failed &
Sort Method of Range Class Failed

Please tell me what it is I have done and how I correct this.......will it help if I have Excel re-installed ?

Thanks

Jamie

 

[mdav2]

I would say that a re-installation probably wouldn't help you much at all.

It may be useful to include the code you are using, this may make it clearer to understand.