Hi. At the end of the month I have 1 sheet that has like 15k rows, and my friend wrote me a macro to delete the rows but I feel like it runs slow. Is there a faster way to delete all row? Here is what I found in the code windows when I click "edit" the macro


Sub ClearAllRows()
Application.ScreenUpdating = False
Dim r As Integer
r = Cells.SpecialCells(xlCellTypeLastCell).Row

for r= UBound(ActiveSheet.UsedRange.Value) to 2 step -1

    Rows(r).Delete

next

Application.ScreenUpdating = True

End Sub