Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subscript out of range problem
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subscript out of range | Excel Discussion (Misc queries) | |||
Subscript out of range problem | Excel Programming | |||
Subscript out of range | Excel Programming | |||
Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range | Excel Programming | |||
Subscript Out of Range | Excel Programming |