array questions

[Cereldine]

Hi, two questions
1) I want to set up a multidimensional array, the array holds field names horizontally and their values vertically. the X dimension will vary depending on how many fields are being passed to it which will vary, the Y dimension will only be two deep, row 1 the field name, row two the field value.
How do i set this up?

2) I also have a loop statement that performs actions on an array. How can i get the loop statement to carry out until it comes across a blank cell? Or if above is implemented until end of array?

MAny thanks

 

[KenHigg]

Sounds like you have some 'Array' experience - I'm guessing you could do this with dao - ?

 

[workmad3]

Multidimensional array

Diim arrayname (X, 2)

As for looping through the array, look into the LBound and UBound functions

Hope this helps

EDIT, a brief look deeper revealed these

Dim arrayname(2, X) for a 2 column, X row array

and

Dim something as Varient

For Each something in arrayname

Next something