Find and Replace in the Comment Field

[Richcarvel]

I know how to find a string in a comment field, but I can't seem to find a
way to do a Find and Replace inside a comment field. Does anyone know how?

 

[Chip Pearson]

Try

Dim CMT As Comment
Set CMT = Range("A1").Comment
CMT.Text Text:=Replace(CMT.Text, "test", "another test")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...

 

[Richcarvel]

Thanks, Chip. Forgive my ignorance of VB. That code replaced one instance
of the text in the spreadsheet, how do I get them all? Thanks. Rich