Thanks Dave. I'll do that too. Otto
"Dave Peterson" wrote in message
...
I like to include "is":

Case is = 34, 116: Call DoThis
Case Is 123, Is < 155: Call DoThat



Otto Moehrbach wrote:

Excel XP & Win XP
I'm trying to write one line of a Select Case construct that encompasses
either one of 2 values. Something like:
Case 34 Or 116: Call DoThis
This line does not do anything, no error, does not call DoThis, nothing.
I could of course write this in 2 lines and that works perfectly.
Can this be written in one line? Thanks for your time. Otto

--

Dave Peterson