Can you use Select Case with multiple target intersects?
For example I have several ranges that format time based on user entry and several ranges that hide rows or columns or force Upper case based upon a user inputting a value into a cell.
I was thinking that I could use something like the below, but I can't figure out how to get the If statement in there 
Any help would be appreciated. Am I barking up the wrong tree?
Select Case Target
Case Application.Intersect(Target, Union(rng1, rng2, rng3, rng4))
Do something
Case Application.Intersect(Target, rng5)
Do something
Case Application.Intersect(Target, rng6)
Do sometihng
End Select
Bookmarks