Range.ClearComments Method

Excel Developer Reference

Clears all cell comments from the specified range.

Syntax

expression.ClearComments

expression   A variable that represents a Range object.

Example

This example clears all comments from cell E5.

Visual Basic for Applications
  Worksheets(1).Range("e5").ClearComments

See Also