Private Sub WorkSheet_SelectionChange(ByVal Target As Range) Application.OnKey "^{a}", "" Dim MyRangeArddress As String MyRangeArddress = Target.Address Sheet2.Cells.Value = "" 'Sheet2.Range(MyRangeArddress).Value = "" Sheet2.Range(MyRangeArddress).Value = Sheet1.Range(MyRangeArddress).Value End Sub