<snip

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.

Sorry if I missed something, but what are those formulae dependent on? Is
it other cells that would trigger the sheet_change event? If so, could you
find those cells (through the sheet_change target range) and trace their
dependents through to the cells you care about, or vice versa, monitor the
precedent cells to the ones you care to monitor?


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.