Is a cell in a range?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DesertCyclist - 28 Nov 2007 22:53 GMT

How can I find out if the ActiveCell is one of the cells in a named range? In
the SheetChange event, I want to take an action only if the cell that was
just changed (Target parameter?) belongs to a certain named range.

Thank you.

Reply to this Message

sebastienm - 28 Nov 2007 22:57 GMT

Hi,
Check whether or not the Intersection of these 2 ranges is nothing or not:

If Not Application(ActiveCell, Range( "<rangename>")) Is Nothing then
''' do something
End if

Signature

Regards,
Sébastien
<http://www.ondemandanalysis.com>

> How can I find out if the ActiveCell is one of the cells in a named range? In
> the SheetChange event, I want to take an action only if the cell that was
> just changed (Target parameter?) belongs to a certain named range.
>
> Thank you.

Reply to this Message

DesertCyclist - 29 Nov 2007 17:18 GMT

Thanks Sebastienm. I think you meant Intersect() and not Application(). This
is great. I didn't know about this. Thanks, again!

> Hi,
> Check whether or not the Intersection of these 2 ranges is nothing or not:
[quoted text clipped - 8 lines]
> >
> > Thank you.

Reply to this Message

sebastienm - 29 Nov 2007 17:28 GMT

Yes sorry: Application.Intersect
Xl also has an Application.Union that can also be very useful.

Signature

Regards,
Sébastien
<http://www.ondemandanalysis.com>

> Thanks Sebastienm. I think you meant Intersect() and not Application(). This
> is great. I didn't know about this. Thanks, again!
[quoted text clipped - 11 lines]
> > >
> > > Thank you.

Reply to this Message