J
John
I am trying to delete the entire row (and move all rows below up) if the
value in Column C for each row is blank. I have used the following code but
it throws up an Next Without For error, not sure where to go from here
Thanks
Sub DeleteZerosinIngredients()
With Application
.ScreenUpdating = False
.Calculation = xlManual
.MaxChange = 0.001
End With
Dim r As Range
For Each r In Selection
Sheets("Ingredient Mix").Select
With ActiveSheet
If Cells(r.Row, 3) = 0 Then r.EntireRow.Delete
Next
End With
With Application
.ScreenUpdating = True
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub
value in Column C for each row is blank. I have used the following code but
it throws up an Next Without For error, not sure where to go from here
Thanks
Sub DeleteZerosinIngredients()
With Application
.ScreenUpdating = False
.Calculation = xlManual
.MaxChange = 0.001
End With
Dim r As Range
For Each r In Selection
Sheets("Ingredient Mix").Select
With ActiveSheet
If Cells(r.Row, 3) = 0 Then r.EntireRow.Delete
Next
End With
With Application
.ScreenUpdating = True
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub