[HELP WITH ARRAY] Simple for you, very hard for me....please
For i = LBound(ary) To UBound(ary)
If IsError(Application.Match(ary(i),Columns(1),0)) Then
Msgbox ary(I) & " not found"
End If
Next i
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Alex" wrote in message
oups.com...
Help please!!!!.
I have a simple array with name of cities in it.
I have in the coloumn "A" a list of city's names.
I should verify that every city included in the array can be found in
the coloumn "A".
How can I do that?. I believe with for, next array.count etc. but I
have many difficulties....
Please help!!!!.
Thanks in advance.
Alex.
|