excel training program - 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