View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mitch Mitch is offline
external usenet poster
 
Posts: 88
Default VBA equivalent for SQL 'IN' function

Thank you Tim. I'll see if I can make it work.

"Tim Williams" wrote:

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?