Range.ClearNotes Method

Excel Developer Reference

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.

Visual Basic for Applications
  Worksheets("Sheet1").Columns("A:C").ClearNotes

See Also