Comments Property

Microsoft Excel Visual Basic

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