I fixed this error (for at least one running of the macro anyway) by implementing the timer macro discussed here:


https://learn.microsoft.com/en-us/an...table-run-time


I add a one second delay and that seems to work. I assume the previous macro I used did not work because I did something wrong.


And this seems to be a common error when pasting, especially from the clipboard, which is what I do a lot. I created another macro for a completely different purpose where I had to paste the same text multiple times. Ran great when I stepped through the code. Would get tripped up on one of the four pastes when run normally.


Added the delay from the above link (thanks to whoever wrote that!) and it works so far.