Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename Defined Names
Hi There,
I am wondering whether it is possible to rename Defined Names ... What is the most convenient way? The way I would do it. - Copy the same "Refers to" ....(range, formula,...) as the orginal Defined Nmae - Give it the New Name & Replace the Old Name with the New Name via "Flexfind" (JKP: http://www.jkp-ads.com) -Delete the Old name Downside ... naah, there is none. It can handle the names used in Data Validation, Conditional Formatting ,... as well! Just wondering whether you have other ways ( a direct one, instead of the creation, finding and deletion way described above) to handle "renaming" Defined Names. Thanks for your comments, Sige |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename Defined Names
Hi
InsertNameDefine Select the name to rename. Type in the new name. Add On worksheets, where the name was used, ReplaceAll OldName with NewName. Select ranges with data validation/conditional formatting, and replace names there too. Delete old name. Probably you can write a procedure for all this too - i.e. the user is asked, which name is to be replaced, and the new name, and all the rest is done by code. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Sige" wrote in message oups.com... Hi There, I am wondering whether it is possible to rename Defined Names ... What is the most convenient way? The way I would do it. - Copy the same "Refers to" ....(range, formula,...) as the orginal Defined Nmae - Give it the New Name & Replace the Old Name with the New Name via "Flexfind" (JKP: http://www.jkp-ads.com) -Delete the Old name Downside ... naah, there is none. It can handle the names used in Data Validation, Conditional Formatting ,... as well! Just wondering whether you have other ways ( a direct one, instead of the creation, finding and deletion way described above) to handle "renaming" Defined Names. Thanks for your comments, Sige |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename Defined Names
Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager to help: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp And don't forget your code will have to change (well, if you used any of those names in the VBA). Sige wrote: Hi There, I am wondering whether it is possible to rename Defined Names ... What is the most convenient way? The way I would do it. - Copy the same "Refers to" ....(range, formula,...) as the orginal Defined Nmae - Give it the New Name & Replace the Old Name with the New Name via "Flexfind" (JKP: http://www.jkp-ads.com) -Delete the Old name Downside ... naah, there is none. It can handle the names used in Data Validation, Conditional Formatting ,... as well! Just wondering whether you have other ways ( a direct one, instead of the creation, finding and deletion way described above) to handle "renaming" Defined Names. Thanks for your comments, Sige -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename Defined Names
Hi Dave,
The "Name Manager" is helping me out already! Thanks, Sige |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete all defined names from a workbook? | Excel Worksheet Functions | |||
How to delete all defined names from a workbook? | Links and Linking in Excel | |||
Using Defined Names in a Chart | Excel Discussion (Misc queries) | |||
Using non defined names from another sheet | Excel Worksheet Functions | |||
Combining Defined Names to New Name For Validation | Excel Worksheet Functions |