Do while loop excel vba - revisited

Dinesh Kumar Takyar
Dinesh Kumar Takyar
53.1 هزار بار بازدید - 12 سال پیش - Quite a few people experienced
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/exc....
12 سال پیش در تاریخ 1391/09/26 منتشر شده است.
53,108 بـار بازدید شده
... بیشتر