Something like this?
![]()
Sub dotch() Dim lRow As Long For lRow = Cells(Cells.Rows.Count, "G").End(xlUp).Row To 2 Step -1 If Cells(lRow, "G") <> Cells(lRow - 1, "G") Then Rows(lRow).EntireRow.Insert Next lRow End Sub
Something like this?
![]()
Sub dotch() Dim lRow As Long For lRow = Cells(Cells.Rows.Count, "G").End(xlUp).Row To 2 Step -1 If Cells(lRow, "G") <> Cells(lRow - 1, "G") Then Rows(lRow).EntireRow.Insert Next lRow End Sub
Click the * Add Reputation below to say thanks.
T124BKT did should have not been separated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks