Thread
:
name deletion
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett