redim preserve multi dimensional array (1 Viewer)

[Liv Manto]

got an array

myarray(0,4) as variant.

I want 0 to be a redimmable

so I could go 0, 1 = a
0,2 = b
0,3 = c
0,4 = d

redim preserve myarray(0+1, 4)

how do you declare this array in the first place?

isnt it supposed to be an empty parentheses -- () in declaration.

 

[Travis]

See this article.
http://support.microsoft.com/default.aspx?scid=kb;en-us;75517

Since you can only redim the rightmost subscript, one way to get the dimension that you want is to know upfront how big you need to make the left subscript(s).

You could also look into other possible solutions such as a recordset or collection.

 

[ChrisO]

Don’t know if this will help or not but there is an attachment in this thread that might.

Best of luck and regards,
Chris.

 

[filo65]

A possible solution:

Dim tmp() as Variant, myarray() as Variant
Dim i as Integer, j as Integer

i=0
redim tmp(4,i)
for j=0 to 4 Step 1
  tmp(j,i) = i *10 *(j+1)
next j

while i < 10
  redim preserve tmp(4,i+1)
  for j=0 to 4 Step 1
    tmp(j,i) = i *10 *(j+1)
  next j
wend


for i = 0 to 9 Step 1
  for j = 0 to 4 Step 1
    myarray(i,j) = tmp(j,i)
  next j
next i

HTH

filo65

 

[Liv Manto]

Thanks y'all. Very much.

Will try.