Excel: Retrieving Cell Notes from a Macro

 Last reviewed: November 29, 1994
Article ID: Q58219
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.

REFERENCES

For more information, see page 202 in the "Microsoft Excel Function Reference," version 4.0 manual. If you are using version 3.0, see page 112 in the "Microsoft Excel Function Reference" version 3.0 manual. If you are using Excel 2.20, see page 239 in the "Microsoft Excel Functions and Macros" version 2.2 manual.

KBCategory: kbother
KBSubcategory:

Additional reference words: 2.2 2.20 3.0 3.00 4.0 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.