+ Reply to Thread
Results 1 to 7 of 7

How can I edit an existing named range scoped to the workbook

  1. 12-23-2022, 02:01 PM #1
    Paul Newton
    Paul Newton is offline
    Registered User
    Join Date
    10-13-2022
    Location
    Northamptonshire, England
    MS-Off Ver
    Excel 2016
    Posts
    56

    How can I edit an existing named range scoped to the workbook

    I have an existing named range, X1Values, scoped to the workbook - see picture

    X1Values.png

    How can I modify the range =Calculations!$B$3:$B$250 to, for example, =Calculations!$B$3:$B$225
    Reply With QuoteRegister To Reply
  2. 12-23-2022, 02:20 PM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: How can I edit an existing named range scoped to the workbook

    CTRL-F3. Select it and then "Edit". Don't forget to save it!!
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 12-23-2022, 02:36 PM #3
    Paul Newton
    Paul Newton is offline
    Registered User
    Join Date
    10-13-2022
    Location
    Northamptonshire, England
    MS-Off Ver
    Excel 2016
    Posts
    56

    Re: How can I edit an existing named range scoped to the workbook

    Thank you Glenn, but since this is the Programming/VBA/Macros forum I didn't specifically say that I need to do this in VBA
    Reply With QuoteRegister To Reply
  4. 12-23-2022, 02:41 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    Re: How can I edit an existing named range scoped to the workbook

    You don't need to edit it. Just create it as though it didn't exist.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  5. 12-23-2022, 02:45 PM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: How can I edit an existing named range scoped to the workbook

    Lol. I never noticed where you'd posted it...

    Mehh!
    Reply With QuoteRegister To Reply
  6. 12-23-2022, 03:00 PM #6
    Paul Newton
    Paul Newton is offline
    Registered User
    Join Date
    10-13-2022
    Location
    Northamptonshire, England
    MS-Off Ver
    Excel 2016
    Posts
    56

    Re: How can I edit an existing named range scoped to the workbook

    Got it, thank you
    Reply With QuoteRegister To Reply
  7. 12-23-2022, 03:29 PM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    Re: How can I edit an existing named range scoped to the workbook

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. UDF to reference named range scoped to sheet
    By dixib in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2022, 02:00 AM
  2. How to Create combined named range using two or more existing named range?
    By ashish4654 in forum Office 365
    Replies: 3
    Last Post: 11-18-2021, 08:40 AM
  3. Adjust existing macro to pick up specific named worksheet and copy to named range
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-08-2017, 12:03 PM
  4. [SOLVED] I want to assign an array to a workbook scoped name
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-28-2016, 07:50 PM
  5. Named formula scoped to workbook are duplicated on worksheet copy.
    By GeneralDisarray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2014, 02:44 PM
  6. [SOLVED] Using VB form in MS Excel to retrieve and edit existing information within a workbook
    By Beam_me_up in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2012, 02:26 PM
  7. Edit Formula but Keep Existing Range
    By jwb21 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2011, 11:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1