I have a macro to delete blank rows in Col M
I have +- 100,000 rows of data so it is fairly slow
It would be appreciated if someone could provide me with code that will speed up the process
I have +- 100,000 rows of data so it is fairly slow
Code:
Sub Del_Blank_Rows_ColM()
Sheets(2).Select
Application.ScreenUpdating = False
Columns("M:M").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Application.ScreenUpdating = True
End Sub
It would be appreciated if someone could provide me with code that will speed up the process