Excel should let me create an automated list of the name box
 

When the name box is used to link cells from other worksheets, or to link
matrices to a single name, for lots of data, one can get lost as to what name
links to what cell/group of cells, especially if it is a "hand-me-down"
spreadsheet. Is there a way to make an automated list that shows you the
name and what cell(s) it links to instead of going through
"InsertNameDefine" and copy the name, paste in Word, then go back and copy
the "Refers to" field and re-paste in Word, n-times?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

You mean something like:
- Activate an empty sheet
- InsertNamePastePasteList

Should give you a two-column list: NamedRanges and RefersTo

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"marisa" wrote in message
...
When the name box is used to link cells from other worksheets, or to link
matrices to a single name, for lots of data, one can get lost as to what
name
links to what cell/group of cells, especially if it is a "hand-me-down"
spreadsheet. Is there a way to make an automated list that shows you the
name and what cell(s) it links to instead of going through
"InsertNameDefine" and copy the name, paste in Word, then go back and
copy
the "Refers to" field and re-paste in Word, n-times?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Select a cell in an empty column.

InsertNamePastePaste List.

This function has been around for many versions of Excel.


Gord Dibben Excel MVP

On Tue, 5 Jul 2005 13:00:02 -0700, marisa
wrote:

When the name box is used to link cells from other worksheets, or to link
matrices to a single name, for lots of data, one can get lost as to what name
links to what cell/group of cells, especially if it is a "hand-me-down"
spreadsheet. Is there a way to make an automated list that shows you the
name and what cell(s) it links to instead of going through
"InsertNameDefine" and copy the name, paste in Word, then go back and copy
the "Refers to" field and re-paste in Word, n-times?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc