Skip to main content

Worksheet.CommentsThreaded property

Table of contents
  1. Syntax
  2. Example

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>