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