Microsoft Office Tutorials and References
In Depth Information
Using the CELL Function
prefix
prefix Returns the text value corresponding to the label prefix
of the cell, as follows:
Returns a single quotation mark (') if the cell contains left-
aligned text.
Returns a double quotation mark (") if the cell contains right-
aligned text.
Returns a caret (^) if the cell contains centered text.
Returns a backslash (\) if the cell contains fill-aligned text.
Returns an empty text ("") if the cell contains anything else.
protect
protect Returns 0 if the cell is not locked and 1 if the cell is
locked. Remember that, by default, all Excel cells start with their
locked property set to TRUE. The locked property is taken into ac-
count only if protection is enabled. This argument for the CELL func-
tion reports a 1 even if protection is not turned on.
type
type Returns the text value corresponding to the type of data in the
cell, as follows:
Returns b for blank if the cell is empty.
Returns l for label if the cell contains a text constant.
Returns v for value if the cell contains anything else.
width
width Returns the column width of the cell, rounded to an integer.
Each unit of column width is equal to the width of one character in the
default font size.
Caution
Be careful with this: It is now possible to change column widths
without causing Excel to calculate. You might have to press F9 to
have the result of this formula change.
reference Is an optional cell reference. If reference is omitted,
CELL returns the information about the last changed cell.
Refer to Figure 12.18 , which shows every CELL option for a specific cell:
cell A1.
reference
Search JabSto ::




Custom Search