View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patel Patel is offline
external usenet poster
 
Posts: 5
Default 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.