No takers from all you Excel experts out there ?
"Gordon" wrote in message
...
Hi there,
I have a VB.NET application which opens a new Excel workbook (and
obviously
worksheet). The cell values in the worksheet depend on certain formulae,
therefore the sheet Calculate event is triggered whenever a calculation
occurs.
My problem is that I can't find a way within this event to find out
exactly
which cell has changed. This is possible with the sheet Change event,
because it passes back the changed row as a parameter, but unfortunately
this event event doesn't get triggered when a calculation occurs, so I
can't
use it.
Are there maybe any Excel.Range events that I can use to resolve this
issue
?
Help !
Gordon.