Does anyone know if it is possible and the syntax to test mutlitple expressions in a select case statement? This is the best I could come up with but it doesn't appear to be working

Example:

Code:
Select Case rng1.value And rng2.value

Case rng1.value = 1 & rng2.value = 2

'code here

case rng1.value = 2 & rng.value = 2

'code here

End Select