Somebody know how works the function CELL("Coord";Reference)?
Hi!
This function is available in Excel97...2003, 2007 as well, but the 1st string parameter depends from localization.
You can use, for example: "ROW", "COLUMN", "ADDRESS" parameter as you can type it in the Excel formula, taking into account localization.
Check its exact typing in Excel help for the CELL() function.
Examples for English version of Excel:
=CELL("ADDRESS",C20) returns $C$20
=CELL("ROW",D3) returns 3
=CELL("COL",D3) returns 4
For Spanish version use ";" instead of "," and use localized string codes instead of the English one.
Regards,
Vladimir