to delete hidden defined names

[Chandana_Gadugu]

I would like to know how can we delete hidden defined names in excel using macro

 

[pgc01]

Hi

Try:

Sub DelHiddenNames()
Dim nm As Name
 
For Each nm In ActiveWorkbook.Names
    If nm.Visible = False Then nm.Delete
Next nm
End Sub