Copy and Paste in a macro is slow can anyone demonstrate quicker code.
I have a very large macro which used a copy and paste code several times while looping through a very large spreadsheet. Attached is a simulated worksheet with a working macro. Can anyone show me how to change the code so the time taken could be reduced. Any assistence would be appreciated.