Deleting Named Ranges
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
carl wrote:
Is there a way to delete all named ranges in a workbook ?
Regards and thank you in advance.
|