| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA error 1004 "Select method of Range class failed"
GOT IT!
Took your code and set it into a separate public subprocedure ... Sheets("SOAUDITITEM").Select Call PubProcedure.pcdrClearSheet Application.Goto Reference:="R2C1" I just select the sheets and call the subprocedure. thanks for your help. "Matt J" wrote: No, it is a click event in another sheet "JE McGimpsey" wrote: Are you running the code from the same worksheet as Sheet SOAUDITSO? In article , Matt J wrote: 1004 error changed to "Method 'Range' of object_'Worksheet' failed" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
| Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
| Error 1004, "select method of range class failed" | Excel Programming | |||
| Runtime Error "1004" Select Method of Range Class Failed | Excel Programming | |||
| error 1004 Select method of Range class failed | Excel Programming | |||
Threaded Mode
