Out of memory when deleting rows

[LabanDC]

I try to run the VBA code below to delete all of the rows is the range row 12-100 what are empty in the C column.
Anyhow I get "out of memory" error when running this. Any idea about why?

For i = 100 To 12 Step -1

If Cells(i, 3) = "" Or Cells(i, 3) = "Name" Then
Range(Cells(i, 1), Cells(i, 2)).Select
Selection.Delete Shift:=xlUp
End If

Next i

Best
Laban

 

[mole999]

without seeing all the elements, what formulas are being adjusted on the sheet you are deleting from, are they all recalculating

are you turning off calculation and screen up dating

does it fail immediately or part way through

does it fail on the same line

 

[mole999]

this is virtually instantaneous

Sub clean()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For i = 100 To 12 Step -1
If Cells(i, 3) = "" Or Cells(i, 3) = "Name" Then Range(Cells(i, 1), Cells(i, 2)).Delete
Next i
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub