Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrey VAriable - How to initialise
I am trying to use a arrey variable as I am not sure of the no of strings I will get back.
Here is my code sample. Sub Macro1() Dim p() As Integer For i = 1 To 10 p(i) = i * 10 '<<<<<< ERROR LINE Next For i = 1 To 10 Debug.Print p(i) Next End Sub I am getting subscript out of range error on line marked above. However if I use Dim p(100) as integer, I do not get error. As far as possible, I would like to use arrey without specifying any upper limit. Pl help. Regards, Madiya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrey Formula | Excel Worksheet Functions | |||
How to avoid arrey formula? | Excel Programming | |||
Active x Initialise prompt | Excel Programming | |||
Userform initialise not executing. | Excel Programming | |||
initialise declaration | Excel Programming |