For Loop

Hi Nick

A loop gets Excel to repeat a piece of code a certain number of times.

The number of times the code gets repeated can be specified as a fixed number (e.g. do this 10 times), or as a variable (e.g. do this for as many times as there are rows of data).

If you know, or can use code to find out, how many times to repeat a block of code you can use a For