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