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
|