2d array search - how ?

D

dx

How can I perform a search in a 2d array?
I had try the Array.indexof() but it returns a RankException error

Dim myArray1(2, 2) As String '2D array
myArray1(0, 0) = "12"
myArray1(0, 1) = "22"
myArray1(1, 0) = "32"
myArray1(2, 0) = "42"
MsgBox(Array.IndexOf(myArray1, "42", 0, 3))
 
H

Herfried K. Wagner [MVP]

* "dx said:
How can I perform a search in a 2d array?
I had try the Array.indexof() but it returns a RankException error

Dim myArray1(2, 2) As String '2D array
myArray1(0, 0) = "12"
myArray1(0, 1) = "22"
myArray1(1, 0) = "32"
myArray1(2, 0) = "42"
MsgBox(Array.IndexOf(myArray1, "42", 0, 3))

Why not loop through the array by using two cascaded 'For...To' loops?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top