Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Named Range (XL 2000 Under Win XP)

    Just a curiosity !

    Have experimented by creating a couple of dynamic named ranges using the OFFSET function. These ranges are used as data sources in a chart. It is really neat because the range dimension(s) automatically change as I add another month's data. Everything is working according to Hoyle, score one for Woody's Lounge.

    I have noticed however, that the dynamic named ranges DO NOT appear in the drop down 'Names' box in the formulabar. I sometimes use this drop down list to select or goto a range so I can check it visually.

    Have I done something wrong, or is this yet another 'Design Feature'

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

    Re: Named Range (XL 2000 Under Win XP)

    You haven't done anything wrong. Dynamic range names are not displayed in the Names box in the formula bar. You can type the name in the Names box, however to select the range. Similarly, dynamic range names are not displayed in the Edit | GoTo dialog, but you can type the name.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Named Range (XL 2000 Under Win XP)

    Thanks Hans,
    Was actually hoping I had done something wrong. It would be nice to have ALL ranges listed. I have downloaded a Utility from http://www.robbo.com.au/ which will list the Dynamic Ranges. This may be useful to others.

    Perhaps that nice Mr Gates will read this and consider it for a future release.

  4. #4
    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

    Re: Named Range (XL 2000 Under Win XP)

    The way I usually "check them visually" to make sure they are correct, is to go into the Insert - name dialog.

    Select the name from the list (they are displayed in the insert name dialog) and select the formula. The range will be "outlined"

    Steve

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

    Re: Named Range (XL 2000 Under Win XP)

    Have you tried name manager by one of our WMVPs, <!profile=pieterse>pieterse<!/profile>?

  6. #6
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Named Range (XL 2000 Under Win XP)

    Ya Right Steve,
    I guess I was looking for the lazy one-click method. Probably our Aussie lay-back culture at work here.

  7. #7
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Named Range (XL 2000 Under Win XP)

    Thanks Tony,
    Had not seen that one. Will of course investigate

  8. #8
    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

    Re: Named Range (XL 2000 Under Win XP)

    It might be a few extra clicks (though once in the insert name dialog, you can look at more than one), for me it beats typing in the name (especially I never remember what I name them sometimes)

    Steve

  9. #9
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Named Range (XL 2000 Under Win XP)

    Hi,

    Glad to see someone is using Naviagtor Utilities! As well as handling Names, it also brings together the features of lots of other utilities by helping you navigate around links, sheets and finding and replacing across multiple sheets and workbooks.

    regards

Posting Permissions

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