This documentation is archived and is not being maintained.

Range.ClearNotes Method

Office 2007
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



Show: