Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does 'Subscript Out of range' mean??
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does 'Subscript Out of range' mean??
Hi Gary
For example if the sheet not exist you will see this error Sheets("dfdsf").Select -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gary" wrote in message ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does 'Subscript Out of range' mean??
Ron has given one example of when you would see that error. There are other
conditions that will generate it. Generally speaking, if you attempt to reference a member of a collection or an array that does not exist, you will get that error. Another example: Dim anyArray(1 To 100) As String Dim myElement As String myElement = anyArray(101) ' will generate the same error. "Gary" wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subscript out of range error in excell | Excel Discussion (Misc queries) | |||
9: Subscript out of range | Excel Discussion (Misc queries) | |||
Subscript out of range error | Excel Discussion (Misc queries) | |||
Run time error 9 : Subscript out of range | Excel Discussion (Misc queries) | |||
Subscript out of range ... sometimes! (Same code unpredictable re | Excel Discussion (Misc queries) |