Selected Cell within named range?

[negcx]

I'm hoping this question is very easy for the experienced Excel/VBA developers on this forum.

I want to use the Worksheet SelectionChange event to update part of my worksheet/UI depending on what cell(s) the user has selected.

As an example, if I have two named ranges - $A$1:$B$10 and $C$1:$D$10 - I want to detect whether the user is in range 1, range 2, or neither, then update elements of the UI.

How can I find out if the Target range is within one of the other ranges?

[shg]

Please Login or Register  to view this content.

[Steel Monkey]

Try something like assuming your names ranges are called "range1" and "range2"(not sure if you want to have this in the selection change or the worksheet change..) :

Please Login or Register  to view this content.

[negcx]

Thanks gentlemen - knew there had to be something simple.

[stanleydgromjr]

negcx,

Please Login or Register  to view this content.

Have a great day,
Stan