Renaming Defined Name

H

hierarchii

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.
 
K

KL

Go to menu Insert>Name>Define
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
 
N

Norman Jones

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
'<<==========================
 
B

Bob Phillips

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)
 
C

Charles Williams

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
 
Top