View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
achidsey achidsey is offline
external usenet poster
 
Posts: 100
Default Editing code to insert two rows

Excel Experts,

I have the following code that goes through a column of data in row C,
starting from the bottom of the row, and inserts ONE blank row each time the
data in cells in Column C changes.

Sub InsertRow()

For i = Cells(Rows.Count, "c").End(xlUp).Row To 1 Step -1
If Cells(i - 1, "c") < Cells(i, "c") Then Rows(i).Insert

Next i

End Sub



How would I modify this code to insert TWO blank rows each time the data in
column C changes.

Thanks,
Alan






--
achidsey