Insert name - delete all

[yshridhar]

Hi everybody
ctrl+shift+F3 (insert|name|create) will allow the user to create names in
the selected range at once.
1) Then how to delete all the named ranges at once?
2) How to edit the named ranges (data range) at once?
Thanks to you all in advance
Regards
Sreedahr

 

[Gary''s Student]

Look at:

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

Just be careful about other Names, like printrange, etc.

 

[yshridhar]

Thanks for your macro. Is there any shortcut or submenu for it.
regards
Sreedhar

 

[Gary''s Student]

Once you have entered the macro, go back to the Excel window and touch

ALT-F8

select the macro, touch the Options button and assign a shortcut key (i
usually use CNTRL-e)