Thread: Remove all define Name
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Remove all define Name
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.
Reply With QuoteReply With Quote