facebook

Articles

VBA - Deleting Range Names* 15/03/2002

To delete all the range names in your workbook, this macro will do the trick.

Sub DeleteNames()
Dim NameX As Name
For Each NameX In Names
ActiveWorkbook.Names(NameX.Name).Delete
Next NameX
End Sub