In the last code posted this line
Code:
For i = 3 To lr Step 2
tells Excel to start looping from the first row to process, in this case 3
to the last row in the column, lr, which was calculated in the preceding line of code
and to work on every second row, the Step 2 part.
Hope that helps.