XLL+ Class Library (7.0)


Creates a note or replaces characters in a note

static int Note(
   LPCTSTR add_text = "",
   const CXlOper& cell_ref = CXlOper::MissingArg(),
   unsigned short start_char = 1,
   unsigned short num_chars = -1



Add_text is text of up to 255 characters you want to add to a note.


Cell_ref is the cell to which you want to add the note text.


Start_char is the number of the character at which you want add_text to be added.


Num_chars is the number of characters that you want to replace in the note. A value of -1 is treated as a missing argument.

Return Value

Zero if the function has been called successfully; non-zero if the function could not be called. See Error codes for a list of return values.


The function is used in the CreateBook sample project, in the InsertSheetAndPopulate() macro.

See the Microsoft Excel on-line Help for full details about this function.


Header: xlfuncs.h

See Also

CXlMacros Class | CXlMacros Methods