View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.