ARRAY IN

  • Thread starter Thread starter Bernie Deitrick
  • Start date Start date
B

Bernie Deitrick

Marina,

RR = Array("John", "mary")
A = "Fred"
If IsError(Application.Match(A, RR, False)) Then
MsgBox "No"
Exit Sub
Else
MsgBox "Yes"
'Other Code
End If

HTH,
Bernie
MS Excel MVP
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel array 2
excel importing data 16
Help in VBA code 5
Letters in the code 3
Trying to run excel vba code when cell value changes from empty to entered value. 1
Macro Box Help 1
Vlookup found what it was looking for, but what cell was in in? 5
for every cell search identical in range, not whole column; how? 2

Back
Top