Insert name - delete all
 

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

Insert name - delete all
 

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.
--
Gary''s Student - gsnu200781


"yshridhar" wrote:

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

Insert name - delete all
 

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

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200781


"yshridhar" wrote:

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

Insert name - delete all
 

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)


--
Gary''s Student - gsnu200781


"yshridhar" wrote:

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

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200781


"yshridhar" wrote:

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