Using Excel VB, Update a specific cell, on any change of anotherspecific cell
Il 28/03/2013 13:16, Claus Busch ha scritto:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E19")) Is Nothing Then
Range("E20") = Range("E19")
End If
End Sub
Hallo Claus,
I tried your solution and it works.
I don't know why the first is Ok for you and not works for me. Strange.
Regards and many thanks
Paul
|