Posted to microsoft.public.excel.programming
|
|
What range is a cell in?
Ye, Bob Phillips does
http://www.google.com/groups?selm=Ov...GP11.phx.gb l
ppsza wrote:
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!
|