On Error Resume Next
Application.DisplayAlerts = False
Dim nr As Name
For Each nr In ActiveWorkbook.Names
Debug.Print nr.Name
nr.Delete
Next
Exit Sub
invalid-reference-pop-up-error-m.png
Do more with
Premium Content
You need an Expert Office subscription to comment.Start Free Trial