Application.CutCopyMode property (Excel)

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.


expression. CutCopyMode

expression A variable that represents an Application object.


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 Starts Cut or Copy mode and shows the moving border.


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

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

Application Object