Shatin wrote:
On a worksheet:

Hello Shatin,
the <Change Event occurs only when cells on the worksheet are changed
by the user
The <Worksheet_Calculate event occurs after the worksheet is recalculated.
So if you disable automatic calculation, you can use the
<Worksheet_Calculate event to update cell 'D1'
But you have to disable automatic calculation , otherwise values are
double counted.

Private Sub Worksheet_Calculate()
Range("D1").Value = Range("D1").Value + Range("C1").Value
End Sub


Mike, from Luxembourg