software

How I test if the name is in a array?

I tryRR= array(quot;Johnquot;, quot;maryquot;)

IF A in RR then
msgbox(quot;yesquot;)
end if

but the IN in if not execute..

thanks for help me

Marina

rr = Array(quot;Johnquot;, quot;maryquot;)

If Not IsError(Application.Match(quot;maryquot;, rr, 0)) Then
MsgBox (quot;yesquot;)
End If--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Marina Limeiraquot; gt; wrote in message
...
gt; How I test if the name is in a array?
gt;
gt; I try
gt;
gt;
gt; RR= array(quot;Johnquot;, quot;maryquot;)
gt;
gt; IF A in RR then
gt; msgbox(quot;yesquot;)
gt; end if
gt;
gt; but the IN in if not execute..
gt;
gt; thanks for help me
gt;
gt; Marina
gt;
gt;
gt;
You have a response to your other post.

Marina Limeira wrote:
gt;
gt; How I test if the name is in a array?
gt;
gt; I try
gt;
gt; RR= array(quot;Johnquot;, quot;maryquot;)
gt;
gt; IF A in RR then
gt; msgbox(quot;yesquot;)
gt; end if
gt;
gt; but the IN in if not execute..
gt;
gt; thanks for help me
gt;
gt; Marina

--

Dave Peterson