by omega0010 » Tue Dec 11, 2012 4:51 pm


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("A1").Address Then
Range("B1").Value = Range("B1").Value + 1
End If
End Sub

The above formula is great but it works only if a data is directly inputted in the cell A1. If A1 = c1-d1 , then the values don’t change in B1 and in my case the live values are coming on cell C1 and D1 from where live difference is constantly updated in A1.
Please give me a solution