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

[Dave Peterson]

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

[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)

"Marina Limeira" <marinalimeiraa@yahoo.com.br> wrote in message
news:OItXcGRHGHA.2036@TK2MSFTNGP14.phx.gbl...
> 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
>
>
>