Return value | Description | |
False | Not in Cut or Copy mode | |
xlCopy | In Copy mode | |
xlCut | In Cut mode |
Set value | Description | |
False | Cancels Cut or Copy mode and removes the moving border. | |
True | Cancels Cut or Copy mode and removes the moving border. On the Macintosh, this also places the contents of the selection on the Macintosh Clipboard. |
Select Case Application.CutCopyMode
Case Is = False
MsgBox "Not in Cut or Copy mode"
Case Is = xlCopy
MsgBox "In Copy mode"
Case Is = xlCut
MsgBox "In Cut mode"
End Select