PDA

View Full Version : When to Use ?CutCopyMode = TRUE???



Cyberdude
06-27-2007, 07:46 PM
The CutCopyMode property can be used to set the value of (or inquire about the status of) the CutCopyMode.
If I have been copying a LOT of cells, then (as I understand it) there will be a large residual amount of information left in the Clip Board. I can clear that information from the Clip Board by entering the VBA statement:
Application.CutCopyMode = False
OK, that’s a good thing … then what? If I want to do some more copying, am I supposed to enter the statement:
Application.CutCopyMode = True
I doubt it. So when would one logically want to set CutCopyMode to True?

Curiously, Help says this:
False……Cancels Cut or Copy mode and removes the moving border
True…….Cancels Cut or Copy mode and removes the moving border
Huh? Looks like the same thing to me.

So why would I ever want to set CutCopyMode to True?

Edit: Change "Clip" to "Cut"

Cyberdude
06-28-2007, 02:38 PM
Surely someone knows the answer to this one. :confused:

Charlize
06-28-2007, 03:04 PM
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