Export (0) Print
Expand All
Expand Minimize
0 out of 7 rated this helpful - Rate this topic

Application.CutCopyMode Property

Office 2007
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 valueDescription
FalseNot in Cut or Copy mode.
xlCopyIn Copy mode.
xlCutIn Cut mode.
Set valueDescription
FalseCancels Cut or Copy mode and removes the moving border.
TrueCancels 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



Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.