List of defined names
 

Hi All,

Is there a way to get a list of the names, that one has defined in a
worksheet, whilst entering a formula into a cell or a graph?

If not is it something other people would find useful?


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=524826

List of defined names
 

When you're ready to insert the range name, press the F3 function key

"coa01gsb" wrote:


Hi All,

Is there a way to get a list of the names, that one has defined in a
worksheet, whilst entering a formula into a cell or a graph?

If not is it something other people would find useful?


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=524826

List of defined names
 

Not easily with a formula.
On an empty sheet, choose InsertNamePastePaste List

--
Kind regards,

Niek Otten

"coa01gsb" wrote in message
...

Hi All,

Is there a way to get a list of the names, that one has defined in a
worksheet, whilst entering a formula into a cell or a graph?

If not is it something other people would find useful?


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=524826

List of defined names
 

You obviously understood the OP's question better than I did!

--
Kind regards,

Niek Otten

"Duke Carey" wrote in message ...
When you're ready to insert the range name, press the F3 function key

"coa01gsb" wrote:


Hi All,

Is there a way to get a list of the names, that one has defined in a
worksheet, whilst entering a formula into a cell or a graph?

If not is it something other people would find useful?


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=524826

List of defined names
 

Thanks,

That F3 bit is going to save me a load of hassle with functions, shame
it doesn't work for graphs


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=524826