ClearComments Method [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | Range Collection