This documentation is archived and is not being maintained.

Worksheet.Comments Property

Office 2007
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



Show: