VBA infinite loop

[kamelkid2]

Please Login or Register  to view this content.

when i hit F5 the excel program just keeps processing and i terminate in the editor by escape key. This is the first loop that I have tried and the guide that I am following has set up their example for the "Do Until" loop differently than I and I cannot apply that method.

what i have done is I have counted all the cells that contain a special character. the cell below that value is put into another worksheet in a running list, and the cell in worksheet "user" that has the special character is deleted. I did a countif of these special characters as a way of letting the code know how many more times it will need to loop but this is obviously not working. is it that the function within the cell does not update between loops and when the loop occurs it still reads the initial value upon looping, thus the infinite loop?

in your experiences, what have you found to be the best way to achieve simple loops?

[TMS]

You set Loopsleft to the value in cell B8 but you don't decrement it in the loop.

Please Login or Register  to view this content.

Regards

[kamelkid2]

You set Loopsleft to the value in cell B8 but you don't decrement it in the loop.

Please Login or Register  to view this content.

Regards

the mathematical side in me is finding this statement very amusing. thank you for your patience and help I think it is starting to come together in my mind. this is rather intuitive

[StevenM]

It depends on what you are trying to do.

Please Login or Register  to view this content.

[TMS]

You're welcome. Thanks for the rep.

[Richard Buttrey]

Hi

In general if you know the number of times something must be done then you should use a For..Next loop.

A Do..Loop (or its variations Do Until..Loop, Do While...Loop, Do..Loop Until, Do...Loop While) is only used when you don't know precisely when something should be terminated.

Your loop variable 'LoopsLeft' never changes from its B8 value, hence the loop never terminates.

Without seeing your workbook its difficult to comment much further. But are you sure you should be using a loop at all. Have you considered a helper column in your data which identifies the special character in the row below, then filter your data on the helper column before using that filtered data.