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