CutCopyMode Property

Applies To

Application Object.

Description

Returns or sets the Cut or Copy mode status, as shown in the following tables. Read-write.

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 in the Macintosh clipboard.


Example

This example uses a message box to display the Cut or Copy mode status.


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