View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
INTP56 INTP56 is offline
external usenet poster
 
Posts: 66
Default Given Address, find named ranges that contain it

Excel 2003

By whatever method, I get to a cell on a worksheet.

Now I want to find out if this cell has a name, or is contained in other
named ranges on the worksheet.

Is there a direct way to get this information? Or do I have to iterate
through all the names myself and determine (Union?) if my cell is in the
named range?

Thanks,

Bob