Sub abc()<br/> For Each cl In ActiveSheet.Comments<br/> If InStr(cl.Text, "ab") Then<br/> cl.Text (Replace(cl.Text, "ab", "abceeffff"))<br/> End If<br/> Next<br/>End Sub