Named Ranges
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Named Ranges

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Does anyone know a quick way to print ALL of the named ranges that i have in my workbook? i need a list of them

    Thanks

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this:

    Code:
    Sub NameList()
        Dim nm As Name
        
        For Each nm In ActiveWorkbook.Names
            Debug.Print nm.Name
        Next nm
    
    End Sub
    This just prints them to the immediate window in the VB editor...you can also have it print to a worksheet.

    HTH,

    Russell

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Get ASAP Utilities freeware add-in at www.asap-utilities.com. It's "Information | List all range names" menu command should do the trick.

    It has lots of other features that make it well worth the trip.

    [ This Message was edited by: Mark W. on 2002-03-22 15:30 ]

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Depending on where you want them, the following code should work OK, Names in column A, ranges they refer to in column B. Change to where you want them displayed: -

    Public Sub NameAll()

    Sheet1.Range("A1").ListNames

    End Sub

  5. #5
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-22 15:30, Mudface wrote:
    Depending on where you want them, the following code should work OK, Names in column A, ranges they refer to in column B. Change to where you want them displayed: -

    Public Sub NameAll()

    Sheet1.Range("A1").ListNames

    End Sub
    I like it!

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks guys.

    Mudface, your solution was perfect!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com