On Feb 28, 12:19 pm, "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

You were close. Just change it to:

Case 34, 116: Call DoThis


HTH,

Mike