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.
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 | Starts Cut or Copy mode and shows the moving border. |
Example
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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.