View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default [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.