Delete a large number of Names from a workbook

  • Thread starter Thread starter Elly
  • Start date Start date
E

Elly

I have a list of over 300 Names/ Named ranges that I need
to delete from a model. I don't want to really sit and
delete them individually from the Insert, Name, Delete
menu. Is there a Macro that can delete a list that I set
up in a worksheet?

Thanks
 
Elly,

If you want to delete every name

For Each nme in Activeworkbook.Names
nme.Delete
Next nme

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top