Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What exactly is the function of Application.CutCopyMode property in Excel

People also ask

What does Application CutCopyMode mean?

CutCopyMode = False clears the clipboard. Without that line you will get the warning ' There is a large amount of information on the Clipboard....' when you close the workbook with a large amount of data on the clipboard.

What does Application ScreenUpdating false mean?

ScreenUpdating Application Property in VBA is used to turn ON/OFF screen updating. If we set ScreenUpdating property to TRUE then it turns on the screen updating else turn off the screen updating. When we set ScreenUpdating property of an application object to false then it will speed up the macro.

What is FormulaR1C1?

Variable R1C1 References FormulaR1C1 inputs a formula into a cell, and the formula is written as a string in the VBA code. This means you can concatenate any numerical variable into the R1C1 formula using string concatenation.

What is VBM in Excel?

Excel VBA is Microsoft's programming language for Excel and all the other Microsoft Office programs, like Word and PowerPoint.


By referring this(http://www.excelforum.com/excel-programming-vba-macros/867665-application-cutcopymode-false.html) link the answer is as below:

Application.CutCopyMode=False is seen in macro recorder-generated code when you do a copy/cut cells and paste . The macro recorder does the copy/cut and paste in separate statements and uses the clipboard as an intermediate buffer. I think Application.CutCopyMode = False clears the clipboard. Without that line you will get the warning 'There is a large amount of information on the Clipboard....' when you close the workbook with a large amount of data on the clipboard.

With optimised VBA code you can usually do the copy/cut and paste operations in one statement, so the clipboard isn't used and Application.CutCopyMode = False isn't needed and you won't get the warning.


Normally, When you copy a cell you will find the below statement written down in the status bar (in the bottom of your sheet)

"Select destination and Press Enter or Choose Paste"

Then you press whether Enter or choose paste to paste the value of the cell.

If you didn't press Esc afterwards you will be able to paste the value of the cell several times

Application.CutCopyMode = False does the same like the Esc button, if you removed it from your code you will find that you are able to paste the cell value several times again.

And if you closed the Excel without pressing Esc you will get the warning 'There is a large amount of information on the Clipboard....'


There is a good explanation at https://stackoverflow.com/a/33833319/903783

The values expected seem to be xlCopy and xlCut according to xlCutCopyMode enumeration (https://msdn.microsoft.com/en-us/VBA/Excel-VBA/articles/xlcutcopymode-enumeration-excel), but the 0 value (this is what False equals to in VBA) seems to be useful to clear Excel data put on the Clipboard.