Multiple Target Intersect Ranges on Same Worksheet

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?

Please Login or Register  to view this content.