Share via

Comment.Author Property

  • Article
Excel Developer Reference

Returns or sets the author of the comment. Read-only String.

Syntax

expression.Author

expression   A variable that represents a Comment 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