Microsoft Office Tutorials and References
In Depth Information
CELL
Table 7.1
INFO_TYPE Examples and Descriptions
Info Type
Return
Returns ( ^ ) for centered text
Returns ( \ ) for fill-aligned text and empty text
Returns ( “” ) for anything else
Protect
Zero for unlocked cells and 1 for locked
Row
Row number of the cell referenced
Type
The text value of the type of data in a cell
Returns ( b ) for blank cells
Returns ( 1 ) for text
Returns ( v ) for anything else
Width
The column width of the cell referenced, rounded off to an integer
Figure 7.1
The CELL function
returns formatting,
location, and content
information about the
cell referenced or
selected.
Additional cell formatting return types are shown in Table 7.2.
Table 7.2
REFERENCE Examples and Descriptions
If Format Is…
Cell Returns…
General
G
0
FO
#,##0
,O
continues
Search JabSto ::




Custom Search