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?
|