Comments Property [Excel 2003 VBA Language Reference]
Returns a Comments collection that represents all the comments for the specified worksheet. Read-only.
For information about returning a single member of a collection, see Returning an Object from a Collection .
Example
This example deletes all comments added by Jean Selva on the active sheet.
For Each c in ActiveSheet.Comments
If c.Author = "Jean Selva" Then c.Delete
Next
Applies to | Worksheet Object
See Also | Author Property | Subject Property