Create list of Named Ranges

[Guest]

Is there a function that will create a list of named ranges and their
locations in a workbook?

 

[Dave Peterson]

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

 

[Guest]

Thanks Dave. I'll look at it.
--
Jim T

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

 

[Guest]

You don't want a function. Use in the Insert menu name and create a name


go to insert menu and select name define

a box will open
type the name abc and press add
then on the botom of the box selectect the icon on the right and select the
cells in the name. the press the icon to close the box and press ok


to use the name simply put in the formula =sum(abc)

 

[Guest]

Insert->Name->paste->paste list