Yes, the loop is hundreds of cycles long but where is it? It takes 20
seconds just holding down the enter key. Is there a way to break out
while testing?

Can you please give instructions on the "Public Flag" suggestion. I
don't know how to do it.

I moved the End With statement but don't see any difference in results.