In this video we look at creating a DO LOOP in Excel VBA. The DO LOOP arrangement allows the section of code between the DO command and the LOOP command to be repeated until a specified condition is true. As the majority of VBA code you write will repeat a process for several lines of data getting to grips with this command will help you write clearer code.
The example in this video is easy to follow and easy to replicate for yourself – so once you have watched the video have a go at getting it to work for yourself.
As always, if you have found the DO LOOP video useful please let us know using the comment box below or Share or Like the video using the buttons above.