Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I was given a worksheet to continue development on and the worksheet contains tons of named ranges (i.e. many, many cells have defined names) which I'd like to simply report out or summarize. Is there a simple way of getting that information without a lot of code, or any code for that matter? I can't seem to find any simple functions for this purpose.

    Thanks a bunch!

    Drew

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post
    Try the very useful add-on, Name Manager, written by one of our moderators, pieterse.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In addition to the NameManager, to just get a list:

    goto a blank section of a worksheet
    Insert - name - paste
    And a list of the names and their formulas will be created ...


    Steve

  4. #4
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I knew it!! I knew there had to be a simple solution!! Gee, do I feel stupid!!

    THANKS!!

    By the way, I'll have a look at the NameManager just the same. Perhaps it might come in handy as well.

    Drew


    [quote name='sdckapr' post='763716' date='05-Mar-2009 15:04']In addition to the NameManager, to just get a list:

    goto a blank section of a worksheet
    Insert - name - paste
    And a list of the names and their formulas will be created ...


    Steve[/quote]

Posting Permissions

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