Searching an Array
Sub Test()
Dim arr(0 To 100, 0 To 200) As String
Dim i As Long
Dim c As Long
arr(50, 50) = "Harry"
For i = 0 To 100
For c = 0 To 200
If arr(i, c) = "Harry" Then
MsgBox "found Harry", , ""
Exit Sub
End If
Next
Next
End Sub
RBS
"Otto Moehrbach" wrote in message
...
Excel 2002, WinXP
I built an array of people's names, say People().
I want to find out if Harry is in that array.
I don't want to find Harry's position within the array, just if he is in
the array.
How would I code that search?
Thanks for your help. Otto
|