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