Hi:
I wrote a piece of code in which i used a two dimension array. I wanted to locate a certain value in this array. Since i know one dimension of where the value is stored i want to fix this dimension and simply look at the other dimension.
The following is the code but it is no good.
Dim aa(3, 3) As String
For n = 1 To 4
For m = 1 To 4
aa(m - 1, n - 1) = n & m
Next m
Next n
' Look for where "23" is stored by lock the second dimension.
MsgBox Application.WorksheetFunction.Match("23", aa(, 2), 0)
Could anybody help me out?
Thanks
Bookmarks