Clears notes and sound notes from all the cells in the specified range.
expression.ClearNotes
expression Required. An expression that returns a Range object.
Example
This example clears all notes and sound notes from columns A through C on Sheet1.
Worksheets("Sheet1").Columns("A:C").ClearNotes