View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
IanKR IanKR is offline
external usenet poster
 
Posts: 97
Default Select Case question

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


Separate them with commas, instead of OR:

Case 34, 116: Call DoThis