Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup using concatenated column indexes | Excel Worksheet Functions | |||
Obtain current RGB settings for color indexes 17 thru 27 | Excel Programming | |||
plz help: creating named range in VBA, loop goes haywire | Excel Programming | |||
multiple chart indexes | Excel Programming | |||
Figuring out what the Shape Indexes are. | Excel Programming |