Microsoft Office Tutorials and References
In Depth Information
Using the CELL Function
formation about the cell in the reference. If you leave off the reference, Ex-
cel returns information about the last cell changed in the workbook.
The argument info_typeis a text value that specifies what type of cell in-
formation you want. The following are the possible values of info_typeand
the corresponding results:
contents
contents Returns the value in the upper-left cell in reference.
address
address Returns the address of the first cell in reference, as text.
As shown in cell B5 of Figure 12.18 , this is always returned in abso-
lute reference style.
Figure 12.18.
Figure 12.18. The
The CELL
CELL function returns information about a specific
function returns information about a specific
cell in this case, cell A1.
cell in this case, cell A1.
row
row Returns the row number of the cell in reference.
col
col Returns the column number of the cell in reference.
Search JabSto ::




Custom Search