Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Named Ranges (Excel 2002)

    Hi

    I have in the past used ASAP Utilities to insert a worksheet which includes all the named ranges in the worbook and their references, I have need to do it again but after searching for ages I can't find out how to do it cany anyone advise please.

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Named Ranges (Excel 2002)

    Was it "ASAP Utilities > Information > List all range names"

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Named Ranges (Excel 2002)

    You can also do it using Charles Williams' and my Name Manager
    Open your workbook with names, hit control-shift-n to start the name manager and hit the button that says :
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Named Ranges (Excel 2002)

    Jan Karel <!profile=Pieterse>Pieterse<!/profile>'s excellent free Name Manager add-in also has this capability. You can download it from JKP-ADS Download page.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Named Ranges (Excel 2002)

    Hi Jan Karel

    Murphy's law kicked in as soon as I finished the post, perhaps this has been useful for others.

    I would like to thank you for your excellent add in which I use all the time.

    Also Thanks to all who replied.

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Named Ranges (Excel 2002)

    You're welcome!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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