Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 4th 08, 06:37 PM posted to microsoft.public.excel.newusers
PA PA is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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.


  #2   Report Post  
Old December 4th 08, 07:25 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default Named Range Question

This is the "go back to cell"

You are in B5 and use GoTo to move to cell named Total
Now you move to H1 and call up GoTo
Now you see $B$5 since that was the cell you were in lately
Eventually GoTo's window will have many such references

You do know you can click the down arrow in the Name box to see a list of
Names? And selecting one of these makes it the active cell.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"PA" wrote in message
...
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.



  #3   Report Post  
Old December 4th 08, 08:07 PM posted to microsoft.public.excel.newusers
PA PA is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 101
Default Named Range Question

Thank you. I never noticed it before, because I always have used the Name
Box drop-down to go to a named cell or range. Some one else noticed it and
asked.

"Bernard Liengme" wrote:

This is the "go back to cell"

You are in B5 and use GoTo to move to cell named Total
Now you move to H1 and call up GoTo
Now you see $B$5 since that was the cell you were in lately
Eventually GoTo's window will have many such references

You do know you can click the down arrow in the Name box to see a list of
Names? And selecting one of these makes it the active cell.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"PA" wrote in message
...
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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Named Range question SGT Buckeye Excel Discussion (Misc queries) 9 November 21st 07 04:07 PM
Named Range Question. LuftRider Excel Discussion (Misc queries) 3 September 24th 07 08:17 PM
Named Range Question Barb Reinhardt Excel Worksheet Functions 4 September 27th 06 04:10 PM
inserting a named range into new cells based on a named cell Peter S. Excel Discussion (Misc queries) 1 June 4th 06 03:53 AM
Named range question Shane Henderson Excel Discussion (Misc queries) 2 April 7th 06 03:38 AM


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017