Comment.Author Property

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

• Comment Object
• Comment Object Members
• Comments Property