Back to lesson
1. In what case would it be preferable to run a For x To y loop instead of a Do loop?
You can't determine how many times you need to loop until run time
You want to loop until a specific condition is met
You know how many times you want the loop to run
2. Each of the following is a valid line of code. Which would let you loop through the macro for each value from 10 to 1.
For lCount = 10 to 1 Step -10
For lCount = 1 to 10
For lCount = 10 To 1 Step -1
3. What is the purpose of the variable "i" in the code below?
It tells the loop how many times to run
It holds the current iteration of the loop
It prints the iteration to the Immediate window
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement