Range.NoteText(Object, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns or sets the cell note associated with the cell in the upper-left corner of the range.

public string NoteText (object Text, object Start, object Length);

Public Function NoteText (Optional Text As Object, Optional Start As Object, Optional Length As Object) As String

Parameters

Text: Object

Optional Object. The text to add to the note (up to 255 characters). The text is inserted starting at position Start, replacing Length characters of the existing note. If this argument is omitted, this method returns the current text of the note starting at position Start, for Length characters.

Start: Object

Optional Object. The starting position for the text that’s set or returned. If this argument is omitted, this method starts at the first character. To append text to the note, specify a number larger than the number of characters in the existing note.

Length: Object

Optional Object. The number of characters to be set or returned. If this argument is omitted, Microsoft Excel sets or returns characters from the starting position to the end of the note (up to 255 characters). If there are more than 255 characters from Start to the end of the note, this method returns only 255 characters.

Returns

String

Remarks

Cell notes have been replaced by range comments. For more information, see the Comment object.

To add a note that contains more than 255 characters, use this method once to specify the first 255 characters, and then use it again to append the remainder of the note (no more than 255 characters at a time).

Applies to