Press Alt+F11 to open the VB editor.

In the VB Editor click on INSERT in the menu and select MODULE

In your new module enter the following macro:

Sub ClearNames()

Dim wb As Workbook
Dim n As Name

For Each n In ThisWorkbook.Names
n.Delete
Next n

Set n = Nothing

End Sub

Save the macro by click on FILE in the menu and selecting SAVE

Press Alt + Q to return to the workbook or click FILE in the menu and select
CLOSE AND RETURN...

From the workbook press Alt + F8, select the macro named ClearNames and
click the RUN button.

Hope this helps...
--
Kevin Backmann


"GOH" wrote:

I have many names inherited from copying worksheet from external files, the
file now contains hundreds of names that is giving me some problems. Apart
from deleting one at a time using 'Insert'-'Name'-'Define', wonder anybody
know how I can delete all the names completely.