| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Entire Row If Column C is Blank
It worked for me without all your additional code in it.
John wrote: Thanks but the code below still comes up with "Next without For" compile error Sub DeleteZerosinSalesMix() With Application .ScreenUpdating = False .Calculation = xlManual .MaxChange = 0.001 End With For Each c In Selection Sheets("Sales Mix").Select With ActiveSheet If Cells(c.Row, c.Column) = "" Then c.EntireRow.Delete Shift:=xlUp Else End If Next c 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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
