Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Range Address Reference (XL97; SR2)

    I'm having difficulty trying to determine the address of all range names within a worksheet. The following code allows me to obtain a list of those range names within a sheet: but no address.

    Sub Start()
    Dim xlnname As Excel.Name
    For Each xlnname In Excel.Names
    ActiveCell = xlnname.Name
    ActiveCell.Offset(1, 0).Select
    Next
    End Sub


    John

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Range Address Reference (XL97; SR2)

    John,

    Range(xlnname).Address should return the range address.

    Andrew C

Posting Permissions

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