Forum Discussion
Excel Copy & Paste / Clipboard
When I copy one or multiple cells from excel, and then go over to another program on my computer and use the "copy" function again, and then go BACK to excel, and paste in a different cell - the original copy from excel is the one that pastes. It's almost like the second copy function from another program on my computer does not slate clean the clipboard - and almost like the excel has its own clipboard that separates itself from the rest of the computer. If i copy a cell in excel, and then copy other stuff from a different program (non microsoft, microsoft, anything really) I want the original excel copy to CLEAR. This is something new and randomly starting occurring over the past year or so to me and all my colleagues. This problem is most prevalent with Bloomberg for me fyi. Thanks for any help!
I'm using ditto and "Application.ScreenUpdating = False" works fine , for maybe some inteference between the clipboard application, only with a delay.
I use Ditto for several advantages, one is to access at his clipboard to retrieve the data that I lose if i unseldct coped cells pressing escape or using "Application.ScreenUpdating = False".
Everytime during this delay i curse the geniuses at microsoft that introduced the persistence of the selection for the copied cells.
for me a macro like this one, works reasonably well
Sub COPPY()
' CTRL+SHIFT+cApplication.ScreenUpdating = False
Selection.Copy
Application.Wait (Now + TimeValue("0:00:01"))
Application.CutCopyMode = False
Application.ScreenUpdating = TrueEnd Sub
