hi,
you get that error when you tell xl to do something it
cann't do.
i am suspecting this line:
Windows("C C Schedule Regular.xls").Activate
i am guessing but is the file name spelled correctly.
If xl opened "Cat.xls" then xl found that file
otherwise xl can't fine "c c schedule regular.xls" to
activate.

-----Original Message-----
The following lines of code yield a "Subscript out of
range" error 9.


Workbooks.Open Filename:= _
"C:\My Documents\cat.xls"
Windows("C C Schedule Regular.xls").Activate

Both xls documents are in the same folder and spelling
including spaces has
been verified as correct. Why does this yield a Subscipt
out of range error?

.