RE: Retrieving the Collection of Ranges in a Workbook

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Adam (Adam_at_discussions.microsoft.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 13:28:31 -0800

Yeah, I figured it out right after I posted, thanks for the info.

Regards,

"K Dales" wrote:

> Clarification: using Names on a work*** gives only the named ranges
> specific to that sheet (e.g. Sheet1!TEST1 vs Sheet2!TEST1) - it will not show
> unqualified ranges that are defined for the entire workbook, even if they are
> on that work***.
>
> "Adam" wrote:
>
> > Not to waste anyones time with this, but what is the easiest way to get a
> > collection of ranges that are named in a workbook?
> >
> > I have tried using Names but it seems to not show all named ranges.
> >
> > Thanks in advance!
> >
> > Regards

Quantcast