How do you delet all the defined range names in a excel file
 

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

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

How do you delet all the defined range names in a excel file
 

Thanks,
--
Helping Is always a good thing


"Wigi" wrote:

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