Try:
![]()
Sub ElConquistador() Dim i As Long For i = ActiveSheet.UsedRange.Rows.count To 2 Step -1 If Range("A" & i).Value <> Range("A" & i).Offset(1).Value Then Range("A" & i).EntireRow.Offset(1).Resize(2).Insert xlDown End If Next i End Sub
Try:
![]()
Sub ElConquistador() Dim i As Long For i = ActiveSheet.UsedRange.Rows.count To 2 Step -1 If Range("A" & i).Value <> Range("A" & i).Offset(1).Value Then Range("A" & i).EntireRow.Offset(1).Resize(2).Insert xlDown End If Next i End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks