For i 1, Excel VBA enters the value 100 into the cell at the intersection of row 1 and column 1.

When Excel VBA reaches Next i, it increases i with 1 and jumps back to the For statement.

For i 2, Excel VBA enters the value 100 into the cell at the intersection of row 2 and column 1, etc.

When Excel VBA reaches Next j, it increases j with 1 and jumps back to the For j statement.

For i 1 and j 2, Excel VBA enters the value 100 into the cell at the intersection of row 1 and column 2.

Next, Excel VBA ignores Next j because j only runs from 1 to 2.

When Excel VBA reaches Next i, it increases i with 1 and jumps back to the For i statement.

For i 2 and j 1, Excel VBA enters the value 100 into the cell at the intersection of row 2 and column 1, etc.

Code placed between Do While and Loop will be repeated as long as the part after Do While is true.

In Excel VBA (and in other programming languages), the symbol means becomes.

As a result, the value 20 will be placed into column A five times (not six because Excel VBA stops when i equals 6).

Excel VBA stops when i equals 7 because Cells(7, 1).Value is empty.

This is a great way to loop through any number of rows on a worksheet.

Excel For Mac Select Like Records