Viewing Named Ranges

[Rob Moyle]

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.

[Roger Govier]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Norman Jones]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[RichardSchollar]

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

[Manoj]

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
>
>