Prevent Do Loops From Becoming Permanent

This tip is extremely useful in the IDE for debugging.

Before the Do loop you want to make safe, you set the var ‘loopnum’ as 0. Then, place these two lines inside the loop:

 If loopnum = 99 Then Err.Raise

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: