需交換兩個不連續儲存格區域的資料?錄製巨集自動化處理:
Exchange。' 判斷是否選取兩個區域
If Selection.Areas.Count = 2 Then
Set XR = Selection.Areas(1)
Set YR = Selection.Areas(2)
' 判斷是否重疊
If Not Intersect(XR, YR) Is Nothing Then
Result = MsgBox("選取區域有重疊!交換後重疊區域資料將被覆蓋!" & vbCrLf & "是否繼續?", vbYesNo)
If Result = vbNo Then Exit Sub
End If
' 判斷大小是否一致
If XR.Rows.Count = YR.Rows.Count And XR.Columns.Count = YR.Columns.Count Then
SZ1 = XR.Formula
SZ2 = YR.Formula
XR.Value = SZ2
YR.Value = SZ1
Else
MsgBox "選取的兩個資料區域大小不一樣!請確認重新選取!"
End If
Else
MsgBox "請按住 Ctrl 鍵選取兩個要交換的資料區域!"
End If
