Range name box
 

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

Range name box
 

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Russell Stevenson" wrote in message om...
How do I code to clear the 'Name Box'?