=Cell("address") will provide the absolute address of the current cell (e.g.
$AG$500)

"Emlou85 via OfficeKB.com" wrote:

Hi

Does anyone know a formula, which displays the cell reference of the cell
that is currently selected?

Thank you
Emma

--
Message posted via http://www.officekb.com