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

    Lost Named Range?

    Hi

    I have a named range called Doctors_1 in my spreadsheet, but I can't find it to edit it, any suggestions please.
    If you are a fool at forty, you will always be a fool

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Does it not appear in Name Manager?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. The Following 2 Users Say Thank You to rory For This Useful Post:

    MartinM (2015-01-15),zeddy (2015-01-15)

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

    Where do i find Name Manager?
    If you are a fool at forty, you will always be a fool

  5. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi Braddy

    In Excel2003:
    Top-panel toolbar: Insert>Name>Define
    In Excel2007/2010
    Top-panel Ribbon:
    Formulas tab>Name Manager

    zeddy

  6. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi Rory

    ..I wanted to be the 100th person to thank you

    zeddy

  7. The Following User Says Thank You to zeddy For This Useful Post:

    rory (2015-01-15)

  8. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Hi zeddy

    Ah - I was wondering!

    Thank you too!
    Regards,
    Rory

    Microsoft MVP - Excel

  9. The Following User Says Thank You to rory For This Useful Post:

    braddy60 (2015-01-15)

  10. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post
    Hi Rory Can I be 101 many thanks
    If you are a fool at forty, you will always be a fool

  11. The Following User Says Thank You to braddy60 For This Useful Post:

    zeddy (2015-01-15)

  12. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi Braddy

    ..to thank Roy properly, look on the left of the bar you use to click the reply, and you will see a 'thanks' button. When you click that, it sends the 'thank you'. It keeps a track of how many times you've sent a 'thanks', and how many times you received a 'thanks'. We like to help everybody, but especially those who have clicked those buttons!
    I'm sending you a 'thanks' now, so it will be the first one you've received!

    zeddy

  13. The Following User Says Thank You to zeddy For This Useful Post:

    braddy60 (2015-01-15)

  14. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Quote Originally Posted by zeddy View Post
    ..to thank Roy properly
    ... just spell my name right...
    Regards,
    Rory

    Microsoft MVP - Excel

  15. #10
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    OK, Right I'll do that in the future...sorry I thought your name was Rory!
    ROTFLOL.gif

    I just couldn't resist!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  16. #11
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Quite understandable, RetiredGreek.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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