Application.CutCopyMode Property

  • Article
Excel Developer Reference

Returns or sets the status of Cut or Copy mode. Can be True, False, or an XLCutCopyMode constant, as shown in the following tables. Read/write Long.

Syntax

expression.CutCopyMode

expression   A variable that represents an Application object.

Remarks

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.

Example

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

Visual Basic for Applications 
  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

See Also