Presumably because XL can't find a window named "C C Schedule
Regular.xls" to activate.



In article ,
"Darrell Wesley" wrote:

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?