Thanks, worked like a charm.

C.
-----Original Message-----
Application.Caller will return a range reference to the
calling cell (or
cells if it is a multicell array formula).

--
Regards,
Tom Ogilvy

"Conceptor" wrote
in message
...
Hi,
Situation: In every one of a workbook's cells, there
is
a formula using a VBA function I created. When a
formula
is being recalculated, my function is being called.
Problem: When mass cells recalculation occurs, my
function needs to know from which cell it is being
called.
Is there a way for my function to know this?

Thanx
C.


.