View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
PA PA is offline
external usenet poster
 
Posts: 101
Default Named Range Question

If naming a range, Excel 2003 and 2007, I usually clcik the Name box, type
the name and press Enter. I then select the name from the Name box drop-down
Someone just noticed that if you use GoTo to select the named range, after
the first or second time in doing this, and absolute reference to a cell not
within the named range is also present in the GoTo dialog box. I have never
seen this before.Can some please explain why the reference to the unrelated
cell.