Returns a Comments collection that represents all the comments for the specified worksheet. Read-only.
Syntax
expression.Comments
expression A variable that represents a Worksheet object.
Example
This example deletes all comments added by author Jean Selva on the active sheet.
For Each c In ActiveSheet.Comments
If c.Author = "Jean Selva" Then c.Delete
Next