Is there a function that will create a list of named ranges and their
locations in a workbook?
--
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

Jim Tibbetts wrote:

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

--

Dave Peterson

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


"Dave Peterson" wrote:

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

Jim Tibbetts wrote:

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

--

Dave Peterson

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)



"Jim Tibbetts" wrote:

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

Insert-Name-paste-paste list

"Jim Tibbetts" wrote:

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