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"
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"