Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RUNTIME ERROR '1004' --- Select method of worksheet class failed
i have the same error when accessing a worksheet. part of my code is a posted below.. Workbooks.Open Filename:="Sales.xls" Sheets("Branch1").Select '== this produces the error as quoted by th subject i need to copy the computations from the selected sheet to anothe file. any help would be appreciated. thanks in advance - jawe ----------------------------------------------------------------------- Posted via http://www.mcse.m ----------------------------------------------------------------------- View this thread: http://www.mcse.ms/message523791.htm |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RUNTIME ERROR '1004' --- Select method of worksheet class failed
Sheets("Branch1").Select
should be: Sheets("Branch1").Activate -- Regards, Bill "jawee" wrote in message ... i have the same error when accessing a worksheet. part of my code is as posted below.. Workbooks.Open Filename:="Sales.xls" Sheets("Branch1").Select '== this produces the error as quoted by the subject i need to copy the computations from the selected sheet to another file. any help would be appreciated. thanks in advance. -- jawee ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message523791.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
RUNTIME ERROR '1004' --- Select method of worksheet class failed
thanks, it worked! :D Bill Renaud wrote: *Sheets("Branch1").Select should be: Sheets("Branch1").Activate -- Regards, Bill "jawee" wrote in message ...[vbcol=seagreen] i have the same error when accessing a worksheet. part of my cod is as posted below.. Workbooks.Open Filename:="Sales.xls" Sheets("Branch1").Select '== this produces the error as quoted b the subject i need to copy the computations from the selected sheet to another file. any help would be appreciated. thanks in advance. -- jawee ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message523791.html [/vbcol] - jawe ----------------------------------------------------------------------- Posted via http://www.mcse.m ----------------------------------------------------------------------- View this thread: http://www.mcse.ms/message523791.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime 1004 error -- insert method of range class failed. | Excel Discussion (Misc queries) | |||
runtime error '1004' delete Method of Range Class Failed | Excel Programming | |||
Runtime Error "1004" Select Method of Range Class Failed | Excel Programming | |||
runtime error '1004' delete Method of Range Class Failed | Excel Programming | |||
excel97: runtime error 1004 select method of range class failed | Excel Programming |