Select Case mistake

[SMcNeill]

A question about Select Case. The query should be: Case Is > 5500 but less than 7000

I just can't do it. I even got a compiler error with it.

Code: (Select All)

Select Case num
    Case 5001 To 6999
        'Do what you need to do
End Select

OR, another way to go about this type thing:

Code: (Select All)

For num = 1 To 100
    Select Case num
        Case Is >= 70 'Do nothing but elimate values > 70
        Case Is > 50 'Do what you need to do
            Print num,
    End Select
Next