Fantastic question. I prefer Fixed Iteration type loops to Indefinite loops because I like to know precisely when something will end (if possible), which is why I rarely encounter infinite loops or crashes. :)
@@ExcelVbaIsFun You are performing the same exact operations as a Do While Loop since you check the condition before the code inside the loop. The Loop syntax allow other people to better recognise that it is a loop. Using the GoTo is a relic of the past and should be avoided at any cost or you could creare spaghetti code: if after the loop you would have needed other code, another GoTo was required so that to exit the loop, while the Loop syntax does exactly that without confusion.
haha. i'm really like the results you run the marco on the first time,because i'm a one of 5 winner :D. Amazing ! Thanks Dan
haha yes, sorry about that! We will def have more contests and drawings, though. :)
Cool! Thanks Dan.
Hey Wayne - thanks for the comments! So glad you liked it, my friend!
Why don't you use a Do Loop!?!?
Fantastic question. I prefer Fixed Iteration type loops to Indefinite loops because I like to know precisely when something will end (if possible), which is why I rarely encounter infinite loops or crashes. :)
@@ExcelVbaIsFun You are performing the same exact operations as a Do While Loop since you check the condition before the code inside the loop. The Loop syntax allow other people to better recognise that it is a loop.
Using the GoTo is a relic of the past and should be avoided at any cost or you could creare spaghetti code: if after the loop you would have needed other code, another GoTo was required so that to exit the loop, while the Loop syntax does exactly that without confusion.
You're right, of course. It works either way. It's only spaghetti code if it's not legible and bounces around illegibly. Thanks for your comments!