Excel Clipboard

I am struggling with this, I keep getting the random Excel error message “There is a large amount of information on the Clipboard. Do you want to be save?” I am pretty sure this message arises from from the fact that the range of cells over greater than 100. However, this is the 6th of 7th iterations of the loop and the first 5 iterations this did not occur. I have read where ESC hotkey will work but that is when the file is being closed, however in my case, there are 35 more iterations of the loop to go through.

Any thoughts and advice would be greatly appreciated!

can you describe how your process looks like and show screenshot with this error ?