Thread: Select Case
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Select Case

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