Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Update only at a specific time. | Excel Discussion (Misc queries) | |||
Update a date cell when a target cell change.... | Excel Discussion (Misc queries) | |||
How to update cell on change | Excel Discussion (Misc queries) | |||
Update a Web Query and be able to change the WebAddress manually from a specific Cell | Excel Programming | |||
Update a cell with a specific value related to a date. | Excel Worksheet Functions |