Microsoft Office Tutorials and References
In Depth Information
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS
3 = Center
4 = Right
5 = Fill
6 = Justify
7 = Center across cells
9
Number indicating the left-border style assigned to the cell:
0 = No border
1 = Thin line
2 = Medium line
3 = Dashed line
4 = Dotted line
5 = Thick line
6 = Double line
7 = Hairline
10
Number indicating the right-border style assigned to the cell. See
argument 9 for descriptions of the numbers returned.
11
Number indicating the top-border style assigned to the cell. See
argument 9 for descriptions of the numbers returned.
12
Number indicating the bottom-border style assigned to the cell. See
argument 9 for descriptions of the numbers returned.
13
Number from 0 to 18, indicating the pattern of the selected cell, as
displayed in the Patterns tab of the Format Cells dialog box, which
appears when you choose the Cells command from the Format menu.
If no pattern is selected, returns 0.
14
If the cell is locked, returns TRUE ; otherwise, returns FALSE .
15
If the cell’s formula is hidden, returns TRUE ; otherwise, returns FALSE .
16
A two-item horizontal array containing the width of the active cell and a
logical value that indicates whether the cell’s width is set to change as
the standard width changes ( TRUE ) or is a custom width ( FALSE ).
17
Row height of cell, in points.
18
Name of font, as text.
19
Size of font, in points.
20
If all the characters in the cell, or only the fi rst character, are bold, returns
TRUE ; otherwise, returns FALSE .
21
If all the characters in the cell, or only the fi rst character, are italic,
returns TRUE ; otherwise, returns FALSE .
22
If all the characters in the cell, or only the fi rst character, are underlined,
returns TRUE ; otherwise, returns FALSE .
23
If all the characters in the cell, or only the fi rst character, are struck
through, returns TRUE ; otherwise, returns FALSE .
24
Font color of the fi rst character in the cell, as a number in the range 1 to
56. If font color is automatic, returns 0.
Search JabSto ::




Custom Search