Hi Mike,
I tried it, but when I run it, the
VB shows error 400
"Mike H" wrote:
Hi,
Right click a sheet tab, view code and paste this in and run it
Sub Kill_Names()
For Each n In ActiveWorkbook.Names
n.Delete
Next n
End Sub
Mike
"Nimesh" wrote:
I have an excel file that has many defined names (appx more than 100), is
there any way to remove all defined name at one go.