Microsoft Office Tutorials and References
In Depth Information
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS
25
If all the characters in the cell, or only the fi rst character, are outlined,
returns TRUE ; otherwise, returns FALSE . Outline font format is not
supported by Microsoft Excel for Windows.
26
If all the characters in the cell, or only the fi rst character, are shadowed,
returns TRUE ; otherwise, returns FALSE . Shadow font format is not
supported by Microsoft Excel for Windows.
27
Number indicating whether a manual page break occurs at the cell:
0 = No break
1 = Row
2 = Column
3 = Both row and column
Part
I
28
Row level (outline).
29
Column level (outline).
30
If the row containing the active cell is a summary row, returns TRUE ;
otherwise, returns FALSE .
31
If the column containing the active cell is a summary column, returns
TRUE ; otherwise, returns FALSE .
32
Name of the workbook and sheet containing the cell. If the window
contains only a single sheet that has the same name as the workbook,
without its extension, returns only the name of the book, in the form
BOOK1.XLS . Otherwise, returns the name of the sheet, in the form
[Book1]Sheet1 .
33
If the cell is formatted to wrap, returns TRUE ; otherwise, returns
FALSE .
34
Left-border color, as a number in the range 1 to 56. If color is automatic,
returns 0.
35
Right-border color, as a number in the range 1 to 56. If color is automatic,
returns 0.
36
Top-border color, as a number in the range 1 to 56. If color is automatic,
returns 0.
37
Bottom-border color, as a number in the range 1 to 56. If color is
automatic, returns 0.
38
Shade foreground color, as a number in the range 1 to 56. If color is
automatic, returns 0.
39
Shade background color, as a number in the range 1 to 56. If color is
automatic, returns 0.
40
Style of the cell, as text.
41
Returns the formula in the active cell without translating it. (This is useful
for international macro sheets.)
42
The horizontal distance, measured in points, from the left edge of the
active window to the left edge of the cell. May be a negative number if
the window is scrolled beyond the cell.
43
The vertical distance, measured in points, from the top edge of the
active window to the top edge of the cell. May be a negative number if
the window is scrolled beyond the cell.
Search JabSto ::




Custom Search