Quite a few people experienced errors while running 'do while' loops in their worksheets and this was mostly due to not defining the variables used. Therefore we describe here the do while loop in Excel VBA for automating calculations and also building in an error due to non-defintion of a variable and how to correct the situation.
For a do while loop to work correctly you need to define:
1. A starting point
2. Condition under which the loop should continue to work or stop
3. Move to the next data (x=x+1).
4. Keep looping by going back to first line of code - 'do while...'
For more details you can log into http://www.familycomputerclub.com/excel/do-while-loop-in-excel.html.
