View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default List all the named ranges & the cells they refer to on a blank she

also:
http://www.jkp-ads.com/officemarketplacenm-en.asp

--
Tim Williams
Palo Alto, CA


"Tim Marsh" <tmarsh-trousers-@-take off my trousers to reply-blueyonder.co.uk wrote in message
...
i believe a free add-in called 'ASAP Utilities' does this (and much more
besides!)


"Hervinder" wrote in message
...
I have a spreadhseet that has approx 50 named ranged defined.

I would like to list all of the named ranges on a blank sheet and the
cells
they refer to.

is this possible within excel itself or would i have to write a macro to
do
it.

If the macro is the only oprion could some please guide me how to do it.

thank you
Hervinder