What I proposed should work if your Summary.xls is OPEN.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TC" wrote in message
...
Don,

Thank you for responding. I had tried this before and
it didn't work. I had tried one more time as you suggested below
but it didn't work. Could you suggest anything else?
This macro is working on version SP1
I'll appreciate any help.

Teresa

"Don Guillett" wrote:

Are you sure? Did you forget .xls?

with Workbooks("SummaryMaster2.xls")
.Activate
.Sheets("Main").Select
end with


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TC" wrote in message
...
Ever since I had newer version of Excel installed I cant run macro
which was executing perfectly before an update.
Excel version: 2003 SP2
VB version: 6.3 9972

Below is the code, which always shows as a stopper €¦.

Workbooks("SummaryMaster2").Activate
Workbooks("SummaryMaster2").Sheets("Main").Select

And the error message is
€œRun-time error €˜9
Subscript out of range€�


Any help will be greatly appreciated.

TC