ClearNotes Method

Applies To

Range object.

Description

Clears notes and sound notes from all the cells in the specified range.

Syntax

expression.ClearNotes

expression Required. An expression that returns a Range object.

See Also

NoteText method, SoundNote property.

Example

This example clears all notes and sound notes from columns A through C on Sheet1.

Worksheets("Sheet1").Columns("A:C").ClearNotes