Hi
I have a similar problem to the post made by jakemaverick http://ozgrid.com/forum/viewthread.php?tid=6151
I have inherited a spreadsheet that has loads of dead names with #ref in them. I have used the code below before clear out all of the names but I need to modify it to delete only the names with #ref.
In addition the workbook has been around the world a few times and as a result it has picked up loads of custom styles that I would also like to delete and then import a select few.
Any advice or code tips would be much appreciated.
Sub Macro1()
Dim Nm As Name
For Each Nm In ActiveWorkbook.Names
Nm.Delete
Next
End Sub
TIA
Graeme