View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
 
Posts: 17
Default 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