View Single Post
  #1   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


I would like to have the contents of E19 copied to E20, with E20
completely editable, however if any changes are made to E19, the
contents are again copied over to E20.
I tried with the following code, but doesn't work.

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

Any suggestion please?
Thanks and Regards
Paul