View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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