Range.ClearNotes Method (Excel)
Clears notes and sound notes from all the cells in the specified range.
Syntax
expression .ClearNotes
expression A variable that represents a Range object.
Return Value
Variant
Example
This example clears all notes and sound notes from columns A through C on Sheet1.
Worksheets("Sheet1").Columns("A:C").ClearNotes