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
|