Worksheet.Comments Property

  • Article
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