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
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"DesertCyclist" wrote:

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.