Named range list

[Murray]

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

 

[Charles Williams]

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]

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










- Show quoted text -

Fantastic - thanks Charles.

I'll download it and give it a go.