View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DesertCyclist DesertCyclist is offline
external usenet poster
 
Posts: 13
Default Is a cell in a range?

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.