Subscript out of range problem
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?
|