CASE - checking for a range ?

[TWELVE]

Hello,

my forum search did not present a solution, so 'm sorry if the answer is already somewhere in a post.

Can i make CASE checking for a range of numbers instead of a single number..?

Example:

Select Value

Case 0-33: do something

Case 34-70:do something else

End Select

This means: if value is somewhere in the range between 0 to 33, then...


Is this possible..? and if so, how is the correct syntax for this..?an
If not, how can i check for a range without tons of If..then statements..?



cheers

TWELVE

[Erel]

Case checks for district values.
You can not use it for checking range of numbers.

[badkarma]

I guess (me again stating the obvious) that you could kludge it ...

sub Main()

CheckMyNum

Select Value
Case "0033": do this
Case "3470": do that
Case Else: do theother
End Select

End Sub

sub CheckMyNum()
Value = "Else"
if mynum >=0 and mynum <=33 then value = "0033"
if mynum >=34 and mynum <=70 then value = "3470"
end sub