macro to delete all named ranges in a workbook en masse?

[Dave F]

Anyone have a quick macro I can use that deletes all named ranges in a macro
en masse?

Thanks,

Dave

 

[T Kirtley]

Dave,

Something like the following should work:

Sub RemoveNames()
Dim nme As Variant
For Each nme In ActiveWorkbook.Names
nme.Delete
Next nme
End Sub


HTH

TK