Author Property

Microsoft Excel Visual Basic

Author Property

       

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

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