Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static Ads As String Dim p As Byte If Target.Address = "$A$1" Then If Ads = "$A$2" Then p = [A1] [A1] = [A2] [A2] = p End If Ads = "$A$1" ElseIf Target.Address = "$A$2" Then If Ads = "$A$1" Then p = [A1] [A1] = [A2] [A2] = p End If Ads = "$A$2" Else Ads = Target.Address End If End Sub