Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |