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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrey VAriable - How to initialise
Hi Madiya,
Am Tue, 16 Jul 2013 03:32:03 -0700 (PDT) schrieb Madiya: 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. an array starts with index 0. You have to specify a upper limit. If you don't do it in declaration part, you have to do it into the code part. Try: Sub Macro1() Dim p() As Integer Dim i As Integer Dim myMax As Integer myMax = 9 ReDim p(myMax) For i = 0 To myMax p(i) = (i + 1) * 10 Next For i = LBound(p) To UBound(p) Debug.Print p(i) Next End Sub Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
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 |