Iterate Array Names with Integers

[AlvaroSiza]

Suppose you have 3 variant Arrays, named sArrPos1, sArrPos2, and sArrPos3.

What is the syntax for using an integer variable to specify which of the three to work with?

e.g.

Please Login or Register  to view this content.

I want to work with sArrPos1 first, then sArrPos2, then sArrPos3, but can't hard type them.

Thanks,

[Norie]

There's isn't one.

[AlvaroSiza]

Bummer.

What if I sent all of my data to one array dimensioned as 1 to n, 1 to 3? So:

Please Login or Register  to view this content.

. Now I've dynamically sized a (1 to n, 1 to 3) array, correct? If I find what I'm looking for in the '2nd Column' position of the array, can I send just that column to the worksheet?

[AlphaFrog]

Declare a variant array with thee elements.
Assign individually column values to one element in the array for each column.. This creates an array of arrays.
Reference the columns within the array by index number.

Please Login or Register  to view this content.

[mikerickson]

AlphaFrog's approach would give you a jagged array. "Jagged", because there might be a different number of elements in the sArrPos(1) than in sArrPos(2).

It sounds like you would be comfortable with that approach, but you can access whole columns (or rows) of an array like this.

Please Login or Register  to view this content.

[AlvaroSiza]

Thank you both. In this case, all three arrays are static and will always be the same number of elements (I always see this as the array's 'depth').

Alpha - I'm off an running with the array of arrays approach. Thanks again.