Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I delete all named ranges in a sheet at one time?
How do I delete all named ranges in a sheet at one time rather than having to
delete them one at a time? -- L.Wall |
#2
|
|||
|
|||
There are lots of names that you may not want to delete (excel creates some
hidden ones that are important.) Get a copy of 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 And you'll be able to pick and choose nicely. L.Wall wrote: How do I delete all named ranges in a sheet at one time rather than having to delete them one at a time? -- L.Wall -- Dave Peterson |
#3
|
|||
|
|||
For Each nme In Activeworkbook.Names
nme.Delete Next nme -- HTH RP (remove nothere from the email address if mailing direct) "L.Wall" wrote in message ... How do I delete all named ranges in a sheet at one time rather than having to delete them one at a time? -- L.Wall |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
return cell from named sheet | Excel Discussion (Misc queries) | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |