One way to do this is use Select Case

Select Case x
Case "code1","code2","code3"
........
case "code4"
.....
End select

Is this what you were looking for?

Alok

"kmbarz" wrote:

Just getting back into vba after a couple of year stint in SAS and Coldfusion
so I'm a bit rusty. Is there something in Excel VBA that works like an IN
operator in other languages? (e.g. var IN ('code1','code2','code3')) I
don't see anything in the help so far.
Thanks