Thread
:
Entering a row everytime column C changes value
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Entering a row everytime column C changes value
try this. the key is working from the bottom up instead of the top down.
Sub insertrowifnotminusonerow()
lr = Cells(Rows.Count, "c").End(xlUp).Row
For i = lr To 2 Step -1
If Cells(i - 1, "c") < Cells(i, "c") Then Rows(i).Insert
Next i
End Sub
--
Don Guillett
SalesAid Software
"aashish" wrote in message
...
I need help creating a macro that will insert a row everytime a value in
column C does not equal the one before it. My data set can be 1000+ rows,
so
doing this manually is a bit mind-numbing. I could also set up may data
so
that a 0 or 1 is indicated every row that needs to have a row inserted.
thanks in advance.
Reply With Quote