View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Select Case Range

Maybe

Select Case True
Case e = 0
'for case 0
Case 0 < e And e < 1
'for case 0<e<1
Case e = 1
'for case 1
Case e < 1
'for all cases above 1
End Select




--
__________________________________
HTH

Bob

"Philosophaie" wrote in message
...
How do you use Select Case if you have a range of numbers like 0<e<1

Not 0<=e<=1 that would be Case 0 to 1.

Here is an example:
Select Case e
Case 0
'for case 0
Case 0<e<1 'this does not work
'for case 0<e<1
Case 1
'for case 1
Case Is <1
'for all cases above 1
end select