Range name box

[Russell Stevenson]

How do I code to clear the 'Name Box'?

 

[Ron de Bruin]

With this macro you can delete the names in your workbook

Sub test()
Dim nm As name
For Each nm In ThisWorkbook.Names
nm.Delete
Next
End Sub