Yes, indeed ... I always forget about all the CELL variants g.


"Harlan Grove" wrote in message
...
"Vasant Nanavati" wrote...
In cell A2, instead of:

A100

use:

=ADDRESS(ROW(A100),COLUMN(A100))
...

Or =CELL("Address",A100)