Creating a range that indexes in a For loop
For i = 2 To 20
If Cells(i, 1) = Cells(i + 1, 1) Then
Else
i = i + 1
Rows(i).Insert
' Here's where I would like to select the range for row i, column 1
through row i, column 12 and then format it with colors, borders, etc.
After that I would continue my loop. How do I write my range to be
able to index the rows since i changes each time that that the "if"
statement isn't true?
End If
Next i
Any help would be appreciated! Thank you.
|