Is there a way to delete all named ranges in a workbook ?
Regards and thank you in advance.
Pete_UK - 31 Aug 2006 19:11 GMT
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
> Is there a way to delete all named ranges in a workbook ?
>
> Regards and thank you in advance.
David Billigmeier - 31 Aug 2006 19:16 GMT
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

Signature
Regards,
Dave
> Is there a way to delete all named ranges in a workbook ?
>
> Regards and thank you in advance.