| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Worksheet.Comments property (Excel) |
vbaxl10.chm175139 |
|
|
c2ad8ea7-0fa3-7cde-e3f2-49bbdb81d261 |
05/15/2019 |
medium |
Returns a Comments collection that represents all the comments for the specified worksheet. Read-only.
expression.Comments
expression A variable that represents a Worksheet object.
This example deletes all comments added by author Jean Selva on the active sheet.
For Each c in ActiveSheet.Comments
If c.Author = "Jean Selva" Then c.Delete
Next[!includeSupport and feedback]