In this video, I will cover the Do While and Do Until loops and how to use these in Excel VBA.
A ‘Do While’ loop allows you to check for a condition and run the loop while that condition is met (or is TRUE).
There are two types of syntax in the Do While Loop.
— Do While
— Do Until
In this video, I show you a really simple example of how you can loop through a range of cells and fill these with numbers.
✅ Download File:
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –
Free Excel Course (Basic to Advanced) –
Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Hi,
I'm trying to figure out how to use Do While loops to copy and paste rows of data into a new worksheet. Any advice would be greatly appreciated. Thanks.
Very well explained👍🏽
Very nice explained ❤️❤️❤️ but I changed something in yours code to give condition on time base but it's not working like I want to run a macro with interval of 5 mint from time 2 pm till 3 pm , really struggling for this , hope you will help me in this ❤️❤️❤️❤️
Superb explained brother.
Thanks…
Really helpful, Thanku
Awsome way of teaching loved it
Hi Sumit, I am Muhammad Naeem, one of your fans from pakistan. I have a problem in writing a VB code for invoice, may you guide me….?
Hi Sumit, nice video again, but I have one question, what is "If _ nothing" and "if not _ nothing statement" in VBA ??
Thank you so much
Nice, widely use function need such this kind of easy and effectively explanation, thanks for making simple