Hi all,

I have a worksheet with about 500 rows, each one containing two columns with calculations in it (some simple formulas like H4 + J4).

Now here's what I need to do:
If one of the two calculations within one row throws a new result, I have to fire some Macros on the same worksheet. That's all.

If I tried to use "Worksheet_Change()" function it worked great, because I can determine the accessed row (which IMHO is not given within the "Worksheet_Calculate()" function). Unfortunately this function does only work for direct user input and not for output cells...

I really just would like to know how this could be done in VBA:

Sub Worksheet_Calculate()
Dim calculatedRow As Integer
calculatedRow = ????
Call myMacro(calculatedRow)
End Sub

Is there any suggestion or am I completely wrong here?

Thanks in advance, Paul