CELL("address", Reference) returns reference of the first cell in reference, as text.
CELL("col", Reference) returns column number of the cell in reference.
CELL("color", Reference) returns 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero).
CELL("contents" Value of the upper-left cell in reference; not a formula.
CELL("coord", Reference) returns absolute reference of the cell range of the first cell in reference, as text.
CELL("filename", Reference) returns filename (including full path) of the file that contains reference, as text.
CELL("format", Reference) returns text value corresponding to the number format of the cell.
CELL("parentheses", Reference) returns 1 if the cell is formatted with parentheses for positive or all values; otherwise returns 0.
CELL("prefix", Reference) returns text value corresponding to the "label prefix" of the cell.
CELL("protect", Reference) returns 0 if the cell is not locked, and 1 if the cell is locked.
CELL("row", Reference) returns row number of the cell in reference.
CELL("type", Reference) returns text value corresponding to the type of data in the cell.
CELL("width", Reference) returns column width of the cell rounded off to an integer.
Reference is the cell that you want information about. If omitted, information specified in info_type is returned for the last cell that was changed.
Reference from Excel help documentation
| 17.1.Cell |
| 17.1.1. | Cell function |
| 17.1.2. | =CELL ("address") returns the address of the last changed cell. |  |
| 17.1.3. | =CELL("color", B3) tells whether B3 is formatted for color-negative numbers |  |
| 17.1.4. | =CELL ("contents",B3) returns the contents of B3. |  |
| 17.1.5. | =CELL ("filename") returns the path, filename, and work sheet name of the workbook and worksheet |  |
| 17.1.6. | =CELL ("format",D1) returns a number format |  |
| 17.1.7. | =CELL ("parentheses", D2) returns 1 if a cell is formatted to have either positive values or all values displayed with parentheses. |  |
| 17.1.8. | =CELL("prefix", A1) returns the type of text alignment in a cell. |  |
| 17.1.9. | =CELL ("protect",A1) returns 1 if a protection is set to locked |  |
| 17.1.10. | =CELL("row", B6) returns the row number of the first cell in the range |  |
| 17.1.11. | =CELL("row", Summary) returns the row number of the first cell in the name |  |
| 17.1.12. | =CELL("type", A1) returns the type of information in a cell. |  |
| 17.1.13. | =CELL("width") returns the width of the last changed cell, rounded to an integer. |  |
| 17.1.14. | =CELL("width", A1) returns the width of A1 |  |