Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Renaming Defined Name
How do you Rename Defined Name? -- rickv ------------------------------------------------------------------------ rickv's Profile: http://www.excelforum.com/member.php...o&userid=25942 View this thread: http://www.excelforum.com/showthread...hreadid=393202 |
#2
|
|||
|
|||
Click "Insert" in the toolbar, and select "Name". Select "Define" and it will bring up a list of all the defined names in the workbook. You can remove a name or change the cell to which the name is attached. Hope this helps. -- hierarchii ------------------------------------------------------------------------ hierarchii's Profile: http://www.excelforum.com/member.php...o&userid=25943 View this thread: http://www.excelforum.com/showthread...hreadid=393202 |
#3
|
|||
|
|||
Go to menu InsertNameDefine
Select the name to rename Change its name and press the 'Add' button Select the old name and press the 'Delete' button Press 'OK' button Another way is to do it by VBA code Regards, KL "rickv" wrote in message ... How do you Rename Defined Name? -- rickv ------------------------------------------------------------------------ rickv's Profile: http://www.excelforum.com/member.php...o&userid=25942 View this thread: http://www.excelforum.com/showthread...hreadid=393202 |
#4
|
|||
|
|||
Hi Rick,
And, if it is a VBA solution that you need, then try something like: '========================== Public Sub Tester() Dim sStr As String With ActiveWorkbook.Names sStr = .Item("OldName").RefersTo .Item("OldName").Delete .Add "NewName", RefersTo:=sStr End With End Sub '<<========================== --- Regards, Norman "rickv" wrote in message ... How do you Rename Defined Name? -- rickv ------------------------------------------------------------------------ rickv's Profile: http://www.excelforum.com/member.php...o&userid=25942 View this thread: http://www.excelforum.com/showthread...hreadid=393202 |
#5
|
|||
|
|||
Rick,
You can't rename a name, you have to delete it and then create a new name with the same refers to value. -- HTH RP (remove nothere from the email address if mailing direct) "rickv" wrote in message ... How do you Rename Defined Name? -- rickv ------------------------------------------------------------------------ rickv's Profile: http://www.excelforum.com/member.php...o&userid=25942 View this thread: http://www.excelforum.com/showthread...hreadid=393202 |
#6
|
|||
|
|||
You can rename a name using VBA
ActiveWorkbook.Names("Joe").Name = "freddy" but any existing references in formulae etc to the previous name will NOT be changed and so will be invalid. regds Charles Williams Decision Models "Bob Phillips" wrote in message ... Rick, You can't rename a name, you have to delete it and then create a new name with the same refers to value. -- HTH RP (remove nothere from the email address if mailing direct) "rickv" wrote in message ... How do you Rename Defined Name? -- rickv ------------------------------------------------------------------------ rickv's Profile: http://www.excelforum.com/member.php...o&userid=25942 View this thread: http://www.excelforum.com/showthread...hreadid=393202 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel is substituting unicode for a defined name of a cell | Excel Discussion (Misc queries) | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
user defined function row number | Excel Worksheet Functions | |||
Defined range problem | Excel Discussion (Misc queries) | |||
User defined charts- font size too small | Charts and Charting in Excel |