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? |
All times are GMT +1. The time now is 03:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com