Hi
Why does this macro run so slow? It takes about 2 min 40 secs to run through a sheet of 170 columns by 2400 rows.
Or is this normal?
Why does this macro run so slow? It takes about 2 min 40 secs to run through a sheet of 170 columns by 2400 rows.
Code:
Sub Delete_Deleted_Schemes()
Application.ScreenUpdating = False
Dim LastRow As Long, c As Long
LastRow = Range("A65536").End(xlUp).Row
For c = LastRow To 2 Step -1
If Cells(c, "C") <> "FY06/07 Programmed" Then
Rows(c).Delete
End If
Next c
End Sub
Or is this normal?