Expand Minimize
1 out of 6 rated this helpful - Rate this topic

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
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.