98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Do Loop
excel training program - Do Loop
Resolved · Low Priority · Version Standard
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?
Thu 3 Jan 2008, 16:55Trainer Stephen said...
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
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 tip:Reconciling a list to correspond with anotherMay have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way. |
