Name box value is not in Name Manager

simmerer

New Member
Joined
Sep 6, 2017
Messages
33
Hello,
I have a spreadsheet with 3 tables which are named. These are displayed in the Formulas tab of the ribbon in Excel 2010, in the Name Manager. However, in addition to those three, another range name is displayed in the Name Box. There was unreadable information in this spreadsheet when I opened it this morning which Excel repaired. I think that is why this name is there.

The range is not needed and does not appear to really refer to any cells. That is, when I select it in the Name Box, no range is selected. How do I get rid of it? I tried Range("Actions4").delete which did not work.

-- removed inline image ---

-- removed inline image ---
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
31,974
Office Version
365
Platform
Windows
Why not just delete it using the name manager?
 

simmerer

New Member
Joined
Sep 6, 2017
Messages
33
Hi Fluff! the name is not in the name manager. It is weird. Selecting the name in the name box does nothing. When I opened the file this morning, I got an error regarding unreadable content. Excel removed stuff to repair. That is probably when this occurred.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
31,974
Office Version
365
Platform
Windows
Not sure if this will help but
File > Check for issues > Inspect Workbook > Inspect
Once finished scroll down & look for hidden names
 

simmerer

New Member
Joined
Sep 6, 2017
Messages
33
I do not see "Check for Issues" in my Excel 2010.
 

simmerer

New Member
Joined
Sep 6, 2017
Messages
33
OK I found it, ran it, and it did not find any hidden names. It does not seem to be causing any issues at this point, so I guess I will just ignore it :(
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
31,974
Office Version
365
Platform
Windows
If this is still a problem, try running this & see what you get
Code:
Sub ListNamedRanges()
  Dim wb As Workbook
  Dim NR As Name
  Dim X As Long
  
  Set wb = ThisWorkbook
  X = 0
  
  ActiveCell.Offset(X, 0).Value = "Name"
  ActiveCell.Offset(X, 1).Value = "Index"
  ActiveCell.Offset(X, 2).Value = "Refers TO"
  ActiveCell.Offset(X, 3).Value = "WB"
  For Each NR In wb.Names
    X = X + 1
    ActiveCell.Offset(X, 0).Value = NR.Name
    ActiveCell.Offset(X, 1).Value = NR.Index
    ActiveCell.Offset(X, 2).Value = "'" & NR.RefersTo
    ActiveCell.Offset(X, 3).Value = NR.ValidWorkbookParameter
    
  Next NR
    
End Sub
Got the code from here
https://www.mrexcel.com/forum/excel-questions/1024971-please-help.html
 

Forum statistics

Threads
1,081,517
Messages
5,359,234
Members
400,523
Latest member
ExcelNewbie98

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top