It keeps doing that same insert for every loop, each time increment the counter to the previous row. It starts at the last row of the range inserting one blank rows, and then moves to the previous row in the range. This macro performs a reverse loop through the chosen range using a counter. 'Step 3: Start reverse looping through the range.įor iCounter = To 2 Step -1