| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error 9 'subscript out of range' using workshhets function
using workbooks.open filename:="C:\test.xls" I can open successfully open
test.xls using worksheets("Sheet1").activate activates worksheet 1 of test.xls however workbooks("test").activate causes error 9 Any suggestions as to the cause. This code worked fine 2 days ago but now I get error 9 for most functions and properties of worksheets. The namespace is correct and the file is open and accessible as proven by the worksheets function. Any help/suggestions gratefully received. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
error 9 'subscript out of range' using workshhets function
workbooks("test.xls").activate
-- Gary''s Student - gsnu200799 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
error 9 'subscript out of range' using workshhets function
Your a star. I can't believe that it was that bloody simple. Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
error 9 'subscript out of range' using workshhets function
You are quite welcome!
-- Gary''s Student - gsnu200799 "Toby" wrote: Your a star. I can't believe that it was that bloody simple. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help! subscript out of range error when trying to return multiple values from function (as variant array) | Excel Programming | |||
| Runtime Error - Subscript out of range despite On Error statement | Excel Programming | |||
| Subscript out of range error - save copy error | Excel Programming | |||
| Subscript out of range error - save copy error | Excel Programming | |||
| Type Mismatch error & subscript out of range error | Excel Programming | |||
Linear Mode
