![]()
Sub x() Dim iRow As Long iRow = 3 Do With Cells(iRow, "C") If IsEmpty(.Value) Then Exit Do If .Offset(-1).Value <> .Value Then .EntireRow.Insert iRow = iRow + 2 Else iRow = iRow + 1 End If End With Loop End Sub
![]()
Sub x() Dim iRow As Long iRow = 3 Do With Cells(iRow, "C") If IsEmpty(.Value) Then Exit Do If .Offset(-1).Value <> .Value Then .EntireRow.Insert iRow = iRow + 2 Else iRow = iRow + 1 End If End With Loop End Sub
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks