Named range list
 

I know that I can generate a list of all my named ranges using Insert-
Name-Paste, which lists the names and the ranges to which those
names refer.

Rather than using Insert-Name-Define to edit what a range refers to,
in a spreadsheet with more than a few named ranges it would be useful
to be able to go back the other way from the pasted list ie edit the
range in the list and then update from that list.

I've played around a bit and thought that "Create" might do the trick
but alas no. Is this at all possible?

Thanks and regards

Murray

Named range list
 

Hi Murray,

You can do this (and lots more) with Name Manager (developed by myself and
Jan Karel Pieterse)
which is freely downloadable from
http://www.DecisionModels.com/Downloads.htm

Use the List button to create the editable List, then the Pickup button to
reload the changed Refersto

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Murray" wrote in message
...
I know that I can generate a list of all my named ranges using Insert-
Name-Paste, which lists the names and the ranges to which those
names refer.

Rather than using Insert-Name-Define to edit what a range refers to,
in a spreadsheet with more than a few named ranges it would be useful
to be able to go back the other way from the pasted list ie edit the
range in the list and then update from that list.

I've played around a bit and thought that "Create" might do the trick
but alas no. Is this at all possible?

Thanks and regards

Murray

Named range list
 

On May 15, 4:31*pm, "Charles Williams"
wrote:
Hi Murray,

You can do this *(and lots more) with Name Manager (developed by myself and
Jan Karel Pieterse)
which is freely downloadable fromhttp://www.DecisionModels.com/Downloads.htm

Use the List button to create the editable List, then the Pickup button to
reload the changed Refersto

Charles
__________________________________________________
The Excel Calculation Sitehttp://www.decisionmodels.com

"Murray" wrote in message

...



I know that I can generate a list of all my named ranges using Insert-
Name-Paste, which lists the names and the ranges to which those
names refer.

Rather than using Insert-Name-Define to edit what a range refers to,
in a spreadsheet with more than a few named ranges it would be useful
to be able to go back the other way from the pasted list *ie edit the
range in the list and then update from that list.

I've played around a bit and thought that "Create" might do the trick
but alas no. Is this at all possible?

Thanks and regards

Murray- Hide quoted text -

- Show quoted text -

Fantastic - thanks Charles.

I'll download it and give it a go.