View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default VBA equivalent for SQL 'IN' function

msgbox
Application.WorksheetFunction.match("help",Array(" this","might","help"),0)

Tim

--
Tim Williams
Palo Alto, CA


"Mitch" wrote in message
...
SQL, SAS and other 'languages' have a set function that allows the

developer
to determine whether a variable's value exists within a set identified in

the
'IN' statement; e.g. If myVar in ("A","B","C") then .....
Is there a VBA equivalent?