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

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

Thanks,

Dave
--
Brevity is the soul of wit.

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

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

"Dave F" wrote:

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

Thanks,

Dave
--
Brevity is the soul of wit.