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