jeudi 10 septembre 2015

Excel VBA IF statement: check against a list of values

I am trying to write an IF like this:

if var [is any of 1,4,5,6,12] then do stuff

But I don't know the syntax for this in VBA, other than:

if var=1 or var=4 or var=5...

which seems a bit clumsy. Any help would be appreciated

Thank you!

Aucun commentaire:

Enregistrer un commentaire