Hello everybody
I found this code
It's supposed to delete every Nth row ..![]()
Public Sub DeleteEveryNthRow(Optional N As Long = 2) 'The default is to delete every 2nd row Dim rDelete As Range Dim i As Long With ActiveSheet Set rDelete = .Rows(N) For i = 2 * N To .UsedRange.Rows.Count Step N Set delRange = Union(rDelete, .Rows(i)) Next i End With rDelete.Delete End Sub
I don't know how to use it?
I tried a lot but failed
Bookmarks