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
add a comment to a worksheet Comments comments property delete comment from worksheet reference all comments in a worksheet

See also: