J
Jim Tibbetts
Is there a function that will create a list of named ranges and their
locations in a workbook?
locations in a workbook?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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
Manager:
You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp
J
Jim Tibbetts
Thanks Dave. I'll look at it.
--
Jim T
--
Jim T
Dave Peterson said: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
J
Joel
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)
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)
D
Duke Carey
Insert->Name->paste->paste list