array names declared on the fly

[GunNam]

Hello,

What I'm trying to do is probably best if a multi-dimensional array is used, but I want to keep it as simple as possible, and I think this is simpler... at least for me.

Okay, so I have Row #1 with 12 cells of data.
I want to put this into an array, which is simple enough: Dim row1array(1 to 12) as string

But say I have 12 ROWS, and I want to dynamically create the array names.
1) Is there a way to do this in the "DIM" declaration inline?
2) Or even if I created the names first in a separate for loop... how would I dereference the string variable I created in the DIM declaration?

i.e.
for loop creates the following array names:
row1array
row2array
row3array
This names are temporarily stored in the variable "myTempArrName"

Now when i tried to declare my array I want to do the following:
Dim myTempArrName(1 to 12) as string <== How to I deference myTempArrName to actually make the array row1array(1 to 12), row2array(1 to 12), etc...

Many thanks

[MarvinP]

Hi GunNam,

I think you are abstracting too hard and cross dimensioning your variable types. I'm not sure the compiler will allow you to Dim a variable string into an array.

I think you have to simply load your values into a 2 dimension array and work with it as that. I think this will be much easier too. You can then have the first number in your array as the row number and the second as the column number. This sounds a lot like Cell notation.

If you want the best site on arrays, look at: http://www.cpearson.com/excel/VBAArrays.htm

[GunNam]

Thanks Marvin,

After I reacquainted myself with a 2 dimensional array... this is definitely the simpler way. I was trying to complicate things with a simple 1 dim array.

Thank you for your input, I'm on the right path.