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.