Bernard,

Application.Caller will return a Range reference pointing to the
cell containing the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"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.