Thread
:
Deleting invisible range names - how?
View Single Post
#
3
June 1st, 2010, 01:40 PM posted to microsoft.public.excel.misc
Don Guillett[_2_]
external usenet poster
Posts: 607
Deleting invisible range names - how?
Option Explicit
Sub deletenameswithREF()
Dim n As Name 'String
For Each n In ThisWorkbook.Names
'MsgBox n.RefersTo 'Name
If InStr(n.RefersTo, "#REF") 0 Then n.Delete
Next
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Kevryl" wrote in message
...
Excel 2007
I have pasted a list of all range names (368 of them in all) and I find a
few that have been obsoleted through their location being cut out (eg
"=#REF!$H$1
"). These show ikn the pasted list but not in the range names editing
dialogue box.
Is there a way to delete them? "Edit" and "Delete" in Formulas / Name
Manager are greyed out.
Don Guillett[_2_]
View Public Profile
View message headers
Find all posts by Don Guillett[_2_]
Find all threads started by Don Guillett[_2_]