Cant Use Copy and Paste when I have and Excel VBA Macro Running
<p>Whenever I run a certain report macro in Excel I cannot use Copy and Paste elsewhere. For instance say I start up the report(depending on how many lines can take 30+ minutes) and then go work elsewhere while its running in the background it doesn't allow me to copy and paste. The only thing it does paste is whatever the Macro is currently working on and If I try to copy something it gets inserted into the next cell on the report messing that report up.</p>

<p>Looking for any advice or if anyone else has heard of this.</p>

<p>Thanks. </p>