Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
name deletion
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
name deletion
Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp It'll make working with names much easier. rk0909 wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple row deletion | Excel Discussion (Misc queries) | |||
Accidental Deletion | Setting up and Configuration of Excel | |||
On deletion of rows | Excel Discussion (Misc queries) | |||
Sheet deletion | Excel Discussion (Misc queries) | |||
#REF! after cell deletion | Excel Discussion (Misc queries) |