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
Watch video Excel VBA to Delete Rows if Cell is Blank - Delete Rows Based on Cell Value - Code Included online without registration, duration 04 minute 16 second in high hd quality. This video was added by user Excel Destination 16 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 21 thousand once and liked it 25 people.