Thread: name deletion
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default name deletion

Sub DeleteAllNames()
For Each N In sheet("sheetname").Names
N.Delete
Next N
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rk0909" wrote in message
...
Hi all,
I want to delete lot of names from a sheet. is there an easy way via a
macro
to delete the names rather than going and deleting them manually.

Thanks much,

RK