Named Range Collection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ExcelMonkey - 31 Jul 2008 18:01 GMT

Is there a named range collection in Excel? Or would I have to create this
collection by looping through all the cells in the UsedRanage and testing to
see if each range had a name?

Thanks

EM

Reply to this Message

Chip Pearson - 31 Jul 2008 18:22 GMT

The Workbook.Names collection contains all the workbook-wide names. The
Worksheet.Names collection contains the sheet level names. E.g.,

Dim WS As Worksheet
Dim N As Name
For Each N In ThisWorkbook.Names
Debug.Print N.Name, N.RefersTo
Next N
For Each WS In ThisWorkbook.Worksheets
For Each N In WS.Names
Debug.Print N.Name, N.RefersTo
Next N
Next WS

Signature

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

> Is there a named range collection in Excel? Or would I have to create
> this
[quoted text clipped - 5 lines]
>
> EM

Reply to this Message

ExcelMonkey - 31 Jul 2008 22:21 GMT

Excellent.

Thanks

EM

> The Workbook.Names collection contains all the workbook-wide names. The
> Worksheet.Names collection contains the sheet level names. E.g.,
[quoted text clipped - 19 lines]
> >
> > EM

Reply to this Message