Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subscript out of range error
Do you use syntax like
Workbooks("Myworkbook").Worksheets("Sheet1") If so, then Workbooks("Myworkbook") is the cause (assuming you have a sheet1) Always use the extension and you won't have problems Workbooks("Myworkbook.xls").Worksheets("Sheet1") -- Regards, Tom Ogilvy Steve wrote in message news:3fd64963$0$1440$afc38c87@... Hello everyone. Is there any reason why a module will run fine on my machine, but others who try to run it get a run time error 9 - subscript out of range error? Is there a setting that needs to be adjusted on their machines? Thanks! -Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error:Subscript out of range | Excel Discussion (Misc queries) | |||
Subscript out of range error | Excel Discussion (Misc queries) | |||
Help on subscript out of range error (VB6/VBA) | Excel Programming | |||
Subscript out of range error | Excel Programming | |||
Subscript out of range error | Excel Programming |