Thanks Bernie, this is the very solution I was looking for! Meanwhile I found
out that =CELL("Row") etc. works in the same way.

Regards,
Stefi


€žBernie Deitrick€� ezt Ã*rta:

Stefi,

=CELL("Address")

but this requires a recalc to update when the selection changes.

HTH,
Bernie
MS Excel MVP


"Stefi" wrote in message
...
Hi All,

I know how to retrieve active cell address with a VBA UDF. My question is
that is there any way to define it with some worksheet function?

Thanks,
Stefi