Bob Phillips ha scritto:

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.



Thank you very much.
This works!. And it's a very powerful command (Application.Match) that
will help me very much in the future.

Thanks again,
Alex.