What range is a cell in?
 

Concerning Excel VBA: Does anyone know of a way that I can find out what range a particular cell (ActiveCell) is in? Here's the situation: I have several named ranges in a worksheet. When a cell changes, if it is in a particular range, then some code needs to be executed, and, if it's in another range, other code needs to be executed

Thanks!

What range is a cell in?
 

I use "Change-Event" processing to detect when a cell value
has been altered. I'm sorry, but to explain it will take
more room than I have available here. See if you can find
an explanation of Event processing somewhere like in John
Walkenbach's book on VBA programming.
-----Original Message-----
Concerning Excel VBA: Does anyone know of a way that I can
find out what range a particular cell (ActiveCell) is in?
Here's the situation: I have several named ranges in a
worksheet. When a cell changes, if it is in a particular
range, then some code needs to be executed, and, if it's in
another range, other code needs to be executed.

Thanks!
.