Iteration and the Loop Builder

Do While or Until

The Loop Builder is a simple tool to insert the usual loop constructions in your program - see animation below. (Learn: an introduction to Do loops)

loop builder

For Each in collection

The For Each loop can be used with arrays and collections, but for collection classes: the VBA Collection class, or such as Sheets or Range in Excel, you will get more support using the corresponding menu.

range for each for each in array for each in collection