View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seamus Conlon Seamus Conlon is offline
external usenet poster
 
Posts: 12
Default Finding if the activecell is withing a named range


Hi,

I have VBA code that is actived with the Worksheet_BeforeDoubleClick event
and I want to
find out if the cell that was double-clicked is within a named range. For
example, if I have a
range named Headers that is defined as A1:H3 and cell B2 is double-clicked I
want to run
the code otherwise I exit the sub.

Any ideas on how to do this?

Thanks.