View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CraigB CraigB is offline
external usenet poster
 
Posts: 3
Default Detect if a selected cell is within a named range

If I have a worksheet with a number of different (non-overlapping)
custom named ares (i.e. part of the WorkSheet.Names collection), is
there any simple way I can detect the region that a selected cell
might be part of?

I could get the row and column index of the cell in question and then
loop through all the Name objects in the collection, testing if it
falls within the R and C range, but I was hoping there might be
something simpler.

Thanks in advance

Craig