Export (0) Print
Expand All
Expand Minimize

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

Cancels Cut or Copy mode and removes 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
Show:
© 2014 Microsoft