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

  • Thread starter Thread starter Flamikey
  • Start date Start date
F

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
 
Flamikey said:
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
Click to expand...

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.
 
Back
Top