Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Delete entire rows by selecting different text in column A | Excel Discussion (Misc queries) | |||
CANNOT DELETE AN ENTIRE COLUMN | Excel Discussion (Misc queries) | |||
Easiest way to delete blank cells in column (not entire row) | Excel Discussion (Misc queries) | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
How to detect an entire column/row delete event? | Excel Programming |