Back to lesson
1. Why is it recommended to add the loop's object variable after the Next command?
To make the code shorter and cleaner
To instruct the loop what it should move to next
To make it clear that you are moving to the next object in the collection
2. Assume you have the code shown below to add 20% to each cell in the range of selected cells. What data type should you declare for the Dim line?
3. What does the code below do?
Places the message "This is " and the worksheet's name in cell A1 on each worksheet of all open workbooks
Places the message "This is " and the worksheet's name in cell A1 on each worksheet
Places the message "This is Sheet1" in cell A1 of Sheet1
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement