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 orig...
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+c
Application.ScreenUpdating = False
Selection.Copy
Application.Wait (Now + TimeValue("0:00:01"))
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub