Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    dynamic range names don't appear in 'Names' box (x

    I think the title of the thread says it all.
    What's the trick? or if this bug is a feature, what's the workaround for a quick way of selecting the whole range, in its current state?
    Thanks

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

    Re: dynamic range names don't appear in 'Names' box (x

    Dynamic ranges have never been visible in the Names box on the left hand side of the menu bar.
    You can still type the name in the Names box to select the range.
    I recommend that you download and install Jan Karel Pieterse's Name Manager add-in (free). It provides a dialog with many more features than the built-in one.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: dynamic range names don't appear in 'Names' bo

    Thanks very much, Hans.
    And Jan Karel for an excellent tool!

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

    Re: dynamic range names don't appear in 'Names' bo

    NO thanks.

    The trick to select a dynamic range is using F5 and typing the name in the box.
    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
  •