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