Do While Loop MS Excel
The use of 'do while' in Excel macros helps us to automate the manipulations that we wish to do with the data in excel worksheet cells. The main points to remember when using a 'do while' loop is:
If we forget to define any of these steps either the loop will not execute correctly or get into an infinite loop. This is what happens when we say the computer has 'hung'. Pre the 'escape =esc' key on the top left of the keyboard to stop the loop and then correct any errors.
Watch the video below to learn
more about the looping process using Excel VBA::
|Watch the video on youtube|