Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error '9' Subscript out of range HELP
Im having this error pop up at such a random time in my app. I have a
combo box with 13 items listed. I have a onclick change event for the combo box and every index works except for the 8th index. After clicking that index, the runtime Error pops up. Anyone have any clue what this may be? The onclick change event is as follows: upcName is a string and cboUPCS is the name of the combo box upcName = cboUPCS Worksheets(upcName).Activate |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error '9' Subscript out of range HELP
It sounds like cboUPCS doesn't have a value that corresponds to a worksheet
name. Maybe extra spaces? Brandon Johnson wrote: Im having this error pop up at such a random time in my app. I have a combo box with 13 items listed. I have a onclick change event for the combo box and every index works except for the 8th index. After clicking that index, the runtime Error pops up. Anyone have any clue what this may be? The onclick change event is as follows: upcName is a string and cboUPCS is the name of the combo box upcName = cboUPCS Worksheets(upcName).Activate -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error 9 subscript out of range | Excel Worksheet Functions | |||
Runtime Error 9, Subscript Out of Range. When linking between word | Excel Discussion (Misc queries) | |||
Runtime Error - Subscript out of range despite On Error statement | Excel Programming | |||
Getting Excel Runtime Error 9: Subscript out of range | Excel Programming | |||
"Subscript out of range Runtime Error 9" | Excel Programming |