Worksheet.Comments Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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 Jean Selva on the active sheet.

For Each c in ActiveSheet.Comments 
 If c.Author = "Jean Selva" Then c.Delete 
Next
Show: