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