CELL

CELL information of type about cell

Synopsis

CELL(type,cell)

Arguments

type: string specifying the type of information requested

cell: cell reference

Description

type specifies the type of information you want to obtain:

address Returns the given cell reference as text.

col Returns the number of the column in cell.

color Returns 0.

contents Returns the contents of the cell in cell.

column Returns the number of the column in cell.

columnwidth Returns the column width.

coord Returns the absolute address of cell.

datatype same as type

filename Returns the name of the file of cell.

format Returns the code of the format of the cell.

formulatype same as type

locked Returns 1 if cell is locked.

parentheses Returns 1 if cell contains a negative value

and its format displays it with parentheses.

prefix Returns a character indicating the horizontal

alignment of cell.

prefixcharacter same as prefix

protect Returns 1 if cell is locked.

row Returns the number of the row in cell.

sheetname Returns the name of the sheet of cell.

type Returns "l" if cell contains a string,

"v" if it contains some other value, and

"b" if cell is blank.

value Returns the contents of the cell in cell.

width Returns the column width.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

INDIRECT.