Worksheet.Comments Property

Excel Developer Reference

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 Jean Selva on the active sheet.

Visual Basic for Applications
For Each c in ActiveSheet.Comments If c.Author = "Jean Selva" Then c.Delete Next

See Also

• Worksheet Object
• Worksheet Object Members
• Author Property