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