Returns a CommentsThreaded collection that represents all the top-level/root comments (no replies) for the specified worksheet. Includes legacy and modern comments. Read-only.
Syntax
expression.CommentsThreaded
expression A variable that represents a Worksheet object.
Example
This example deletes all threaded comments added by author Jean Selva on the active sheet.
For Each C In ActiveSheet.CommentsThreaded
If C.Author.Name = "Jean Selva" Then C.Delete
Next