Try:-
Mick![]()
Sub InsertRowAtChangeInValueCSR() Dim lRow As Long For lRow = Cells(Cells.rows.Count, "F").End(xlUp).row To 2 Step -1 If Cells(lRow, "F") <> Cells(lRow - 1, "F") Then rows(lRow).Resize(2).EntireRow.Insert Next lRow End Sub
Try:-
Mick![]()
Sub InsertRowAtChangeInValueCSR() Dim lRow As Long For lRow = Cells(Cells.rows.Count, "F").End(xlUp).row To 2 Step -1 If Cells(lRow, "F") <> Cells(lRow - 1, "F") Then rows(lRow).Resize(2).EntireRow.Insert Next lRow End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks