excel array
 

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

excel array
 

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)

"Marina Limeira" wrote in message
...
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

excel array
 

You have a response to your other post.

Marina Limeira wrote:

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

--

Dave Peterson