Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Do Loop
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel training program - Do Loop
Resolved · Low Priority · Version Standard
Reply Fri 14 Dec 2007, 16:11Delegate Kitu said...
Kitu has attended:
Excel VBA Intro Intermediate course
Do Loop
What is the difference between the For and Do loops?
For upcoming training course dates see: Pricing & availability
RE: Do Loop
Hi Kitu
Thankyou for your question
All loops carry out a series of operations until a condition is met
A For Loop will execute for a predetermined number of loops.
For i = 1 to 100
CODE
Next i
This Will carry out the code will the variable i is less than or equal to 100. i will increase by 1 at every loop, so the code will be run for 100 loops
A DO Loop will typically compare one variable with another variable or a constant and execute the code while a specified condition holds
Do until A > B
CODE
Loop
This will execute the code as long as the variable A is less than the variable B
|