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)

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.