Microsoft Office Tutorials and References
In Depth Information
USE GET.CELL TO HIGHLIGHT NON-FORMULA CELLS
The horizontal distance, measured in points, from the left edge of the
active window to the right edge of the cell. May be a negative number if
the window is scrolled beyond the cell.
The vertical distance, measured in points, from the top edge of the
active window to the bottom edge of the cell. May be a negative number
if the window is scrolled beyond the cell.
If the cell contains a text note, returns TRUE ; otherwise, returns
If the cell contains a sound note, returns TRUE ; otherwise, returns
If the cells contains a formula, returns TRUE ; if a constant, returns
If the cell is part of an array, returns TRUE ; otherwise, returns FALSE .
Number indicating the cell’s vertical alignment:
1 = Top
2 = Center
3 = Bottom
4 = Justiﬁ ed
Number indicating the cell’s vertical orientation:
0 = Horizontal
1 = Vertical
2 = Upward
3 = Downward
The cell preﬁ x (or text alignment) character, or empty text (“”) if the cell
does not contain one.
Contents of the cell as it is currently displayed, as text, including any
additional numbers or symbols resulting from the cell’s formatting.
Returns the name of the PivotTable view containing the active cell.
Returns the position of a cell within the PivotTable view.
Returns the name of the ﬁ eld containing the active cell reference if
inside a PivotTable view.
Returns TRUE if all the characters in the cell, or only the ﬁ rst character,
are formatted with a superscript font; otherwise, returns FALSE .
Returns the font style as text of all the characters in the cell, or only the
ﬁ rst character, as displayed in the Font tab of the Format Cells dialog
box (for example, " Bold Italic ".)
Returns the number for the underline style:
1 = None
2 = Single
3 = Double
4 = Single accounting
5 = Double accounting