ClearNotes Method

Microsoft Excel Visual Basic

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