I have a select case statement

I want to use the "Or" logic so that I have

Select Case State

Case "OR" or "NY"

But this logic does not work, nor does Application.Or("OR","NY")

Does anyone know how to use the Or statement in a select case.

Thanks for your help

Just use commas
case "A","B"

--
Don Guillett
SalesAid Software

"Jeff" wrote in message
...
I have a select case statement

I want to use the "Or" logic so that I have

Select Case State

Case "OR" or "NY"

But this logic does not work, nor does Application.Or("OR","NY")

Does anyone know how to use the Or statement in a select case.

Thanks for your help