Private Sub CommandButton1_Click()
Dim temp
temp = Range("a1").Value
Range("a1").Value = Range("b1").Value
Range("b1").Value = Range("c1").Value
Range("c1").Value = temp
End Sub
直接改变值,不改变格式就行了
Private Sub CommandButton1_Click()
Dim temp
temp = Range("a1").Value
Range("a1").Value = Range("b1").Value
Range("b1").Value = Range("c1").Value
Range("c1").Value = temp
End Sub
直接改变值,不改变格式就行了