+ Reply to Thread
Results 1 to 4 of 4

Cannot delete a range name

  1. #1
    Registered User
    Join Date
    11-24-2013
    Location
    florida
    MS-Off Ver
    Excel 2010 & 2013
    Posts
    29

    Cannot delete a range name

    Workbook contains a number of named ranges where the name is no longer used. I wish to remove the name assigned but not the actual range of referenced cells. When using Name Manager to try and delete the name the Delete button is greyed out and not available. Workbook is being heavily modified from its original form used by another. Is this possibly from a protected area from prior user?
    However, I have not had a problem creating new worksheets, cell ranges, etc. Also, even for new ranges I create I am not able to delete the name as the Delete button is greyed. What is going on and how can I delete just the unused range names?
    Version is Excel 2010.
    Last edited by RonRich; 11-28-2013 at 08:53 AM. Reason: Change title for clarification

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Cannot delete a range name

    Could they be table names? If so they must be converted back to "normal" ranges before they can be deleted.

  3. #3
    Registered User
    Join Date
    11-24-2013
    Location
    florida
    MS-Off Ver
    Excel 2010 & 2013
    Posts
    29

    Re: Cannot delete a range name

    YES! Thanks Alf. Did not realize that as table names they had to be converted. Tried it on one and all is OK.

  4. #4
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Cannot delete a range name

    Glad to be of help and thanks for feedback!

    Alf

+ 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. Delete Worksheets not on list or in named range?
    By Unpackedrope in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-09-2013, 04:12 PM
  2. Alert if User Attempts to Delete Row Containing Named Range
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2013, 12:04 AM
  3. [SOLVED] delete all oleobjects in named range
    By Willardio in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-24-2012, 02:47 PM
  4. Search Cell Value Delete if Not in Named Range
    By Julia55 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-04-2012, 05:39 PM
  5. Delete from named range based on Combo Box selection
    By shebert in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2005, 12:18 PM

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