Insert name - delete all

  • Thread starter Thread starter yshridhar
  • Start date Start date
Y

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
 
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.
 
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)
 
Back
Top