Hi Mike,
Your macro is working fine. Thanks buddy. I'll try to found out the reason
why its not happening on particular machine. It worked very smoothly on other
machine.
Again thanks.

"Mike H" wrote:

Hi,

I can't reproduce that error.

Mike

"Nimesh" wrote:

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.