Viewing Named Ranges
 

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

Viewing Named Ranges
 

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

Viewing Named Ranges
 

Hi Rob,

As you are working extensively with named ranges, you should download Jan
Karel Pieterse's invaluable Name Manager addin, which can be downloaded,
free of charge, at:

http://www.jkp-ads.com/Download.asp


---
Regards,
Norman


"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

Viewing Named Ranges
 

Hi Rob

As a quick and dirty method, you can reduce the zoom on the worksheet
to 39% and below and then the named ranges will be delineated and
visible.

Hope this helps!

Best regards

Richard

Viewing Named Ranges
 

Hit F5 and see if this serves your purpose.

"Rob Moyle" wrote:


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