Is there a way to delete all named ranges in a workbook ? Regards and thank you in advance.
C carl Aug 31, 2006 #1 Is there a way to delete all named ranges in a workbook ? Regards and thank you in advance.
P Pete_UK Aug 31, 2006 #2 Here's a little snippet of VBA to do that: For Each nme In ActiveWorkbook.Names nme.Delete Next nme I can't remember who posted it originally, but I find it very useful. Hope this helps Pete
Here's a little snippet of VBA to do that: For Each nme In ActiveWorkbook.Names nme.Delete Next nme I can't remember who posted it originally, but I find it very useful. Hope this helps Pete
D David Billigmeier Aug 31, 2006 #3 Download and install Name Manager (link below). It is a great tool for managing all of your named ranges. In Excel 2007 a similar tool is included as default, until then gotta do this extra little step: http://www.jkp-ads.com/officemarketplacenm-en.asp
Download and install Name Manager (link below). It is a great tool for managing all of your named ranges. In Excel 2007 a similar tool is included as default, until then gotta do this extra little step: http://www.jkp-ads.com/officemarketplacenm-en.asp
