View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wigi Wigi is offline
external usenet poster
 
Posts: 396
Default How do you delet all the defined range names in a excel file

Hi

consider

Dim n As Name

For Each n In ThisWorkbook.Names
n.Delete
Next

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"QuietMan" wrote:

I working with a file that has around 400 defined ranges and I would like to
know if there is a vba command that delete all the ranges quiclkly

Thanks

--
Helping Is always a good thing