Any known Add-In to find/replace......

[Flamikey]

text strings in comments? I have some very large files riddled with
comments from past users. I would like to find the "Entered BY" names
in the comments and replace all in one step. Thx

 

[Beto]

text strings in comments? I have some very large files riddled with
comments from past users. I would like to find the "Entered BY" names
in the comments and replace all in one step. Thx

Sub ChangeCommentsName()
Set cmt = Worksheets("Hoja2").Comments
For Each c In cmt
c.Text "New Name:" & Chr(10) & Right(c.Text, _
Len(c.Text) - InStr(c.Text, ":") - 1)
Next
End Sub

This might get you started.