Hi please can someone help? I'm using Excel to write a simple factory picking list. I want to be able to clear the contents on Sheet- 'Pick Lists' row 7 to 41 by clicking a command button on Sheet 'Master 800'. I recorded a macro for this purpose and it works perfectly, however, when I paste the macro into a command button I get an error message stating: "runtime error 1004, select method of range class failed". I don't understand why it's falling down when it works ok as a stand alone macro?. Anyway, anybody's help would be much appreciated.
Cheers
Joecod