G Guest Jul 13, 2005 #1 How do I delete all named ranges in a sheet at one time rather than having to delete them one at a time?
How do I delete all named ranges in a sheet at one time rather than having to delete them one at a time?
D Dave Peterson Jul 13, 2005 #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.
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.
B Bob Phillips Jul 13, 2005 #3 For Each nme In Activeworkbook.Names nme.Delete Next nme -- HTH RP (remove nothere from the email address if mailing direct)
For Each nme In Activeworkbook.Names nme.Delete Next nme -- HTH RP (remove nothere from the email address if mailing direct)
