Array of ArrayNames
Hi
why not use a multi-dimensional array. Something like
Dim aMulit(1 to NumOfArray, 1 to 20)
--
Regards
Frank Kabel
Frankfurt, Germany
"ewize1" schrieb im Newsbeitrag
...
Hi,
Let's say I have a finite list arrays of varies sizes, but the size
of each
array is unknow during declaration. I have another array which stores
the
name of each array declared. How can I use a loop to assess each
element in
each array? Line 3 of the code doesn't work.
Const NumOfArray = 3
Dim Array1() As String
Dim Array2() As String
Dim Array3() As String
Dim ArrayList(NumOfArray) As String
1: For j = 1 to NumOfArray
2: For i = 1 to Ubound(Array(ArrayList(j)))
3: column = WorksheetFunction.Match(Array(ArrayList(j))(i),
Rows(1), 0)
4: Next i
5: Next j
How can I solve it?
--
We can do no great things; only small things with great love
|