Could you set a value such that, when the sheet is calculated, another cell
changes to a known value? eg set A2 as =A1 then change A1. Then test A2
before data transfer.

--
Ian
--
"Lavneet Singh"
wrote in message
news:Lavneet.Singh.1yukxn_1132577702.7295@excelfor um-nospam.com...

Hi,

Thanks Leith Ross and Ian for your replies.

Ian: The recalculation could be triggered externally (by user, for
example) too. In such a case, is there a way to find if recalculation
is done?

Leith Ross: The application in question uses COM via .net interop (C#)
that basically uses Excel APIs directly. We aren't listening to window
message loop. Sorry for using a potentially misleading word
('hooked').

Thanks,
Lavneet.


--
Lavneet Singh
------------------------------------------------------------------------
Lavneet Singh's Profile:
http://www.excelforum.com/member.php...o&userid=28942
View this thread: http://www.excelforum.com/showthread...hreadid=486771