"Select Case"... do nothing! SOLVED.

[Airfix9]

Hi all,

Searched with no luck for an answer on this.... When I use "Select Case", how do I get my code to do nothing in certain circumstances?

Example (and the maximum value of i could be any integer, as defined elsewhere):

    Select Case i
        Case 1
            'do something
        Case 2 - 5
            'do something else
        Case 6 - 8
            'do nothing at all <-------
        Case Else
            'do something entirely different
    End Select

Any help gratefully received.

 

[Richard Schollar]

Something like:

    Select Case i 
        Case 1 
            'do something 
            'code.....
        Case 2 - 5 
            'do something else 
            'code........
        Case 6 - 8   'leave blank!
        Case Else 
            'do something entirely different 
            'code....
    End Select

 

[Airfix9]

Thanks Richard.

(Runs away crying, it was so simple!)