Hi RickV,

Try:

'===========================
Public Sub Tester()
Dim Nme As Name
Dim sStr As String
Dim strOldName As String
Dim strNewName As String

Const myPrefix As String = "xxx"

For Each Nme In ActiveWorkbook.Names

If Nme.Name Like "bb*" Then
sStr = Nme.RefersTo
strOldName = Nme.Name
strNewName = myPrefix & strOldName
ActiveWorkbook.Names.Add strNewName, RefersTo:=sStr
Nme.Delete
End If

Next Nme

End Sub
'<<=======================


---
Regards,
Norman



"rickv" wrote in
message ...

There are thousands of Defined name to be renamed. The prefix of these
defined names is bb and would like to change the prefix to xxxbb. These
defined names are used in formulae. How do I create the macro or vba to
do the job.
Thanks for your help.


--
rickv
------------------------------------------------------------------------
rickv's Profile:
http://www.excelforum.com/member.php...o&userid=25942
View this thread: http://www.excelforum.com/showthread...hreadid=393501