Public MyFunction( )
set rng = Application.Caller
rw = rng.row
col = rng.column
MyFunction = rng.address
End Function

--
Regards,
Tom Ogilvy

"Bernard" wrote in message
...
Hi-

Is there any way a formula can get the location of the cell it is placed
in? I need the row and column of the cell at recalculation time, not at
the
time formula was entered, so ActiveCell won't do the job.

Thanks in advance for any help.