ClearComments Method [Excel 2003 VBA Language Reference]
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