Excel VBA to Delete Rows if Cell is Blank - Delete Rows Based on Cell Value - Code Included
This Excel VBA Tutorial explains VBA Code to delete rows when cell is blank. You can use For Loop with If Condition to write VBA code to delete rows based on cell value condition.
VBA Code , used in this example is as follows :
a = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To a
If Worksheets("Sheet1").Cells(i, 3).Value = "" Then
Rows(i).Delete
End If
Next
