GET.NOTE
Returns characters from a comment.
Syntax
GET.NOTE(cell_ref, start_char, num_chars)
Cell_ref is the cell to which the note is attached. If cell_ref is omitted, the comment attached
to the active cell is returned.
Start_char is the number of the first character in the comment to return. If start_char is
omitted, it is assumed to be 1, the first character in the comment.
Num_chars is the number of characters to return. Num_chars must be less than or equal to
255. If num_chars is omitted, it is assumed to be the length of the comment attached to
cell_ref.
Examples
The following macro formula returns the first 200 characters in the comment attached to cell
A3 on the active sheet:
GET.NOTE(!$A$3, 1, 200)
In Microsoft Excel for Windows, the following macro formula returns the 10th through the 39th
characters of the comment attached to cell C2 on SALES.XLS:
GET.NOTE("[SALES.XLS]Sheet1!R2C3", 10, 30)
224
In Microsoft Excel for the Macintosh, the following macro formula returns the 10th through the
39th characters of the comment attached to cell C2 on SALES:
GET.NOTE("[SALES]Sheet1!R2C3", 10, 30)
Use GET.NOTE with the NOTE function to move the contents of a comment to a cell or text box
or to another comment attached to a cell:
NOTE(GET.NOTE(!$B$10),ACTIVE.CELL())
Related Functions
GET.CELL Returns information about the specified cell
NOTE Creates or changes a comment.
Nezkoušel jsem, snad bude k užitku, uvidíte, zkuste.
Zdroj:
https://d13ot9o61jdzpp.cloudfront.net/files/Excel%204.0%20Macro%20Functions%20Reference.pdfcitovat
Returns characters from a comment.
Syntax
GET.NOTE(cell_ref, start_char, num_chars)
Cell_ref is the cell to which the note is attached. If cell_ref is omitted, the comment attached
to the active cell is returned.
Start_char is the number of the first character in the comment to return. If start_char is
omitted, it is assumed to be 1, the first character in the comment.
Num_chars is the number of characters to return. Num_chars must be less than or equal to
255. If num_chars is omitted, it is assumed to be the length of the comment attached to
cell_ref.
Examples
The following macro formula returns the first 200 characters in the comment attached to cell
A3 on the active sheet:
GET.NOTE(!$A$3, 1, 200)
In Microsoft Excel for Windows, the following macro formula returns the 10th through the 39th
characters of the comment attached to cell C2 on SALES.XLS:
GET.NOTE("[SALES.XLS]Sheet1!R2C3", 10, 30)
224
In Microsoft Excel for the Macintosh, the following macro formula returns the 10th through the
39th characters of the comment attached to cell C2 on SALES:
GET.NOTE("[SALES]Sheet1!R2C3", 10, 30)
Use GET.NOTE with the NOTE function to move the contents of a comment to a cell or text box
or to another comment attached to a cell:
NOTE(GET.NOTE(!$B$10),ACTIVE.CELL())
Related Functions
GET.CELL Returns information about the specified cell
NOTE Creates or changes a comment.
Nezkoušel jsem, snad bude k užitku, uvidíte, zkuste.
Zdroj:
https://d13ot9o61jdzpp.cloudfront.net/files/Excel%204.0%20Macro%20Functions%20Reference.pdfcitovat
RSS nejnovější články