Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to code to insert / delete any worksheet? | Excel Worksheet Functions | |||
cut and delete a row then insert and copy | New Users to Excel | |||
Macro auto insert/delete | Excel Discussion (Misc queries) | |||
delete every X row, insert everyY row | Excel Discussion (Misc queries) | |||
can't insert, delete or move pictures | Excel Discussion (Misc queries) |