Hi Rob

Download a free copy of Bastien Mensink's excellent Add in ASAP
Utilities
http://www.asap-utilities.com/

This has a feature in the Information section to List all Named ranges
on a separate sheet along with their definitions (along with numerous
other useful utilities)

--
Regards

Roger Govier


"Rob Moyle"
wrote in message
...

Hi All,

I've done some searches and can't find what I'm looking for - not sure
if it's possible or not?

I have a worksheet with anywhere between 50 - 80 different defined
named ranges on it.

I need to update the sheet occassionally by inserting new details
(with
a corresponding new range name), as well as deleting or editing
existing
ranges.

What I'd like to know is: Is there a way I can view the sheet so that
it shows the different ranges that have names - similar to using the
"View Formulas" check in the Excel Options, but to view ranges
instead?

Am I pushing my luck here?! ; )

Cheers,

Rob.


--
Rob Moyle
------------------------------------------------------------------------
Rob Moyle's Profile:
http://www.excelforum.com/member.php...o&userid=30432
View this thread:
http://www.excelforum.com/showthread...hreadid=549797