excel array

[Marina Limeira]

How I test if the name is in a array?

I try


RR= array("John", "mary")

IF A in RR then
msgbox("yes")
end if

but the IN in if not execute..

thanks for help me

Marina

 

[Bob Phillips]

rr = Array("John", "mary")

If Not IsError(Application.Match("mary", rr, 0)) Then
MsgBox ("yes")
End If


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Dave Peterson]

You have a response to your other post.

How I test if the name is in a array?

I try

RR= array("John", "mary")

IF A in RR then
msgbox("yes")
end if

but the IN in if not execute..

thanks for help me

Marina