List of defined names

[coa01gsb]

Hi All,

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

If not is it something other people would find useful

 

[Duke Carey]

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

 

[Niek Otten]

Not easily with a formula.
On an empty sheet, choose Insert>Name>Paste>Paste List

 

[Niek Otten]

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

 

[coa01gsb]

Thanks,

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