Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ReDim Array
I have an array that I use for many different things. Thus the size of the
array may vary depending on the different tasks. I declare the array in a sub and then poulate the array with contents depending on an index number that has been sent to the sub. Code: Private arrayMaker(index As Integer) Dim array(1 to 100) As Variant if index = 0 then array(0) = "Interest rate" array(1)="Delta" rayy(2)=...etc. end if if index =1....etc.. end if As you can see there is no point in setting one size for every array. Instead I want to ReDim the array depending on the number of inputs I use. How do you do this? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ReDim Array
Private arrayMaker(index As Integer)
Dim varray() As Variant if index = 0 then redim varray(0 to 2) varray(0) = "Interest rate" varray(1)="Delta" varray(2)=...etc. end if if index =1....etc.. Redim varray(0 to 10) end if .. . . End Sub -- Regards, Tom Ogilvy "Viktor Ygdorff" wrote: I have an array that I use for many different things. Thus the size of the array may vary depending on the different tasks. I declare the array in a sub and then poulate the array with contents depending on an index number that has been sent to the sub. Code: Private arrayMaker(index As Integer) Dim array(1 to 100) As Variant if index = 0 then array(0) = "Interest rate" array(1)="Delta" rayy(2)=...etc. end if if index =1....etc.. end if As you can see there is no point in setting one size for every array. Instead I want to ReDim the array depending on the number of inputs I use. How do you do this? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ReDim Array
Great thanks! Is there any way of counting the input data so that if new info
is to be added to the array you dont have to change the dimension but just add another line with the data? That would be very nice but your code works fine! Thank you ver much! "Tom Ogilvy" skrev: Private arrayMaker(index As Integer) Dim varray() As Variant if index = 0 then redim varray(0 to 2) varray(0) = "Interest rate" varray(1)="Delta" varray(2)=...etc. end if if index =1....etc.. Redim varray(0 to 10) end if . . . End Sub -- Regards, Tom Ogilvy "Viktor Ygdorff" wrote: I have an array that I use for many different things. Thus the size of the array may vary depending on the different tasks. I declare the array in a sub and then poulate the array with contents depending on an index number that has been sent to the sub. Code: Private arrayMaker(index As Integer) Dim array(1 to 100) As Variant if index = 0 then array(0) = "Interest rate" array(1)="Delta" rayy(2)=...etc. end if if index =1....etc.. end if As you can see there is no point in setting one size for every array. Instead I want to ReDim the array depending on the number of inputs I use. How do you do this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA syntax help: ReDim Preserve an array | Excel Discussion (Misc queries) | |||
ReDim Object array as parameter of Variant array | Excel Programming | |||
Dim / Redim of an Array | Excel Programming | |||
Redim 2D Array Subscript Out Of Range Error | Excel Programming | |||
ReDim an Array | Excel Programming |