+ Reply to Thread
Results 1 to 3 of 3

Un-naming named ranges

  1. #1
    Registered User
    Join Date
    12-19-2022
    Location
    HAFB, Utah
    MS-Off Ver
    2016
    Posts
    2

    Un-naming named ranges

    I have a spreadsheet that for various reasons I would like to un-name about 400 named ranges. For instance, in the Name Manager, I have a value of 3.5 that is assigned to "Slk_B" and a range of $A$1:$A$5 assigned to "Plot_bb"

    I need to undo all those named ranges to simply be back to their absolute ranges. Is there a way to do this? I've been doing it by hand with some find and replace.

    Thanks,

    Matt

  2. #2
    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,036

    Re: Un-naming named ranges

    I haven't ever done this on a large scale... but it looks like it can be done using VBA:

    https://answers.microsoft.com/en-us/...8-773a5084032e
    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

  3. #3
    Registered User
    Join Date
    12-19-2022
    Location
    HAFB, Utah
    MS-Off Ver
    2016
    Posts
    2

    Re: Un-naming named ranges

    Thanks Glenn. I'll take a look at this thread and see if I can make it work. I'll report back.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dynamic chart ranges without naming lots of ranges
    By benoj2005 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-21-2020, 04:30 AM
  2. Copy values of all named range in wb1 to identically named ranges in wb2
    By JAMIAM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2016, 06:58 PM
  3. [SOLVED] VBA creates named ranges, but named ranges disappear
    By BrotherNeptune in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2015, 03:22 PM
  4. Define only 2 named ranges from a list of named ranges...
    By abhi900 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2014, 04:20 AM
  5. Looping Mutliple Named Resized Ranges in next empty row below another named range
    By gingumdog in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2014, 08:15 PM
  6. Replies: 7
    Last Post: 05-27-2013, 01:40 PM
  7. Replies: 1
    Last Post: 03-21-2006, 06:40 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1