Get.cell
www.sulprobil.com/html/get_cell.html
Note created April 4, 2009 Last edited April 5, 2009 by helmut.mittelbach@googlemail.com
4/5/09
You can retrieve
interesting information about worksheet cells by using the Excel4 macro function
GET.CELL. Define the name HasFormula with the
value
=GET.CELL(48,INDIRECT("RC[-1]",FALSE))
for example. If you now
insert =HasFormula next right to a cell, you will be shown whether the cell has
a formula (True) or not (False).
Another example for GET.CELL you can find here.
An overview over some arguments for GET.CELL:
Proposed Name |
Arg # |
What =GET.CELL(Arg #,INDIRECT("RC[-1]",)) will return |
AbsReference |
1 |
Absolute style reference like [Book1.xls]Sheet1!$A$1 |
ShowValue |
5 |
Cell value |
ShowFormula |
6 |
Cell formula |
NumFormat |
7 |
Number format of cell |
IsLocked |
14 |
True if cell is locked |
IsHidden |
15 |
True if cell is hidden |
ShowWidth |
16 |
Cell width. If array-entered into two cells of a row, second value is true if width is standard |
ShowHeight |
17 |
Cell height |
WorkbookName |
32 |
Workbook name like [Book1.xls]Sheet1 or Book1.xls if workbook and single sheet have identical names |
ShowFormulaWOT |
41 |
Cell formula without translation into language of workspace |
HasNote |
46 |
True if cell has a text note |
HasFormula |
48 |
True if cell contains a formula |
IsArray |
49 |
True if cell is part of an array formula |
IsStringConst |
52 |
Text alignment char if cell is a string constant, empty string if not |
AsText |
53 |
Cell displayed as text with numbers formatted and symbols included |
WorksheetName |
62 |
Worksheet name like [Book1.xls]Sheet1 |
WorkbookName |
66 |
Workbook name like Book1.xls |