Hi
not quite sure what you're trying to do but have a look at
application.caller

--
Regards
Frank Kabel
Frankfurt, Germany


Conceptor wrote:
Hi all,

I need to know from what particular workbook, worksheet and cell a
given macro function is called from. The call could be made from a
worksheet.calculate, a user pressing enter in the cell, or any other
mean that would trigger the calculation of the formula in the cell.

How can I achieve it?

Thanks,
C.