Select Case mistake

[SMcNeill]

Cannot have multiple conditions in "CASE IS".

That's not quite right.  You just won't generate the answers you're expecting, I don't imagine. 

Code: (Select All)

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

Multiple CASE IS statements seem to work as OR comparisons and not AND comparisons.  In this case it's basically IF num >50 OR num < 70, which is all our numbers...  

Looks like TO is the solution for numbers in a range.