Microsoft KB Archive/58219

{|
 * width="100%"|

Excel: Retrieving Cell Notes from a Macro

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

-

SUMMARY
The Microsoft Excel GET.NOTE function returns the note from a given cell when the function is called from a command macro. The function, in the form GET.NOTE(cell_ref,start_char,count_char), has the following three optional arguments:


 * 1) cell_ref - The reference of the cell containing the note. If cell_ref is omitted, it is assumed to be the active cell.
 * 2) start_char - The first character to be read. If start_char is omitted, it is assumed to be 1.
 * 3) count_char - The number of characters to be read. If count_char is omitted, it is assumed to be the length of the note attached to cell_ref.

The count_char argument must be less than or equal to 255. The start_char argument is limited only by the number of characters in the note. For example, if a note contains 510 characters, to obtain the last 255 characters, use the following formula

  =GET.NOTE(cell_ref,256,255)

where 256 is the number to begin extracting from and 255 is the number of characters to extract.