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