How to force long loops to end

[danleonida]

I've been looking for a simple solution for the title question and I became an expert at everything, but! Up until 20 minutes ago, that is and I want to share the solution:

Please Login or Register  to view this content.

Hope it works for all as well as it works for me! I made a text box in the spreadsheet and linked it kill_macros. One click and I see the R.I.P. message in cell macro_msgs!!

Edit for the benefit of the visually impaired:

How to force long loops to end

Loops can be endless by design! Like in shuffling cards! Try using For, Do or While to shuffle a deck of cards!

Lesson learned:

Some gurus around here seem to be guruer then other gurus, while the undersigned seems to be the guruest guru on the topic!

Comments/critiques welcome!

[protonLeah]

Please lookup For..Next, For Each..Next, Do..Loop and While..Wend to see how loops are actually written these days. Then lookup Exit For, Exit Do to see how to check for a condition and exit a loop.