How do I detect if a cell contains a comment? I want to add a comment to the cell if it does not already contain one.
VBA help says that the syntax for setting a comment's text is:
Worksheets(1).Range("E5").Comment.Text "reviewed on " & Date
However when I record a macro it comes up with:
Range("I11").Comment.Text Text:="IS:" & Chr(10) & ""
What is the reason for the extra Text:= in the recorded macro?