December 23, 2019 at 4:51 pm
#4828
Inactive
Thanks, I had from Shawn. I just hated to replace all of the waits I had. I typically have a Loop Count variable that I reset to 0 before each do loop and then when the counter got to the pain point, I had it error out the procedure and handle error.
Typically looked like this:
LC = LC+1: DoEvents: Wait 1
: At ""
I also thought of updating DoEvents to Doevents_ which I believe adds a half second wait to the DoEvents