cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Paste Worksheet Range failing at full speed

Anonymous
Not applicable
Hi all, I am copying pasting data between two excel files. When debugging at full speed it misses about 50% of the copy/paste process, pasting an empty range. I have tried clearing the clipboard before each copy/paste, but it's not helping. When debugging with breakpoints it never fails. Iterating over different files is not consistent and each time the copy/paste process fails in different elements. Have you come across this issue? Is there any workaround? Thanks, Juan.
1 REPLY 1

John__Carter
Staff
Staff
I guess it takes time for data to transfer to and from the clipboard, the slow speed of debug mode provides this time, but the full speed of Control Room does not. Would introducing some waits help?