What exactly is the function of Application CutCopyMode property in Excel

Question

Well first of all I found couple of answers while googling but most of the forums are blocked in my Office Network hence asking this question here  One more intention is to get an answer in plain English  P  I understand if we set Application CutCopyMode   False then the Copied Cut results will be vanished  i e  memory will be cleared  but when should we use this and when not to use this  Can anyone please help

User · Answer

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

User · Answer

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

User · Answer

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

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

Examples related to vba

Examples related to excel

Examples related to excel-2010