Select Case mistake

[mnrvovrfc]

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

Cannot have multiple conditions in "CASE IS".

Code: (Select All)

select case num
    case is > 5500
        if num < 7000 then
            'do what you need to do
        end if
end select

If you need to do something else for "num >= 7000" then you must create another case for it above the one displayed.