Named range list

  • Thread starter Thread starter Murray
  • Start date Start date
M

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
Click to expand...
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
 
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 -
Click to expand...

Fantastic - thanks Charles.

I'll download it and give it a go.
 
Back
Top