excel same value in two cells
This macro will do as you describe.........
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then
Range("a2").Value = Range("a1").Value
Else
If Target.Address = "$A$2" Then
Range("a1").Value = Range("a2").Value
Else
End If
End If
End Sub
Vaya con Dios,
Chuck, CABGx3
"pls help" wrote:
How can 2 cells have the same values, such that when I edit either cell the
change is reflected on both?
|