ClearComments Method

Microsoft Excel Visual Basic

ClearComments Method

       

Clears all cell comments from the specified range.

expression.ClearComments

expression   Required. An expression that returns a Range object.

Example

This example clears all comments from cell E5.

Worksheets(1).Range("e5").ClearComments