Excel VBA to Delete Rows if Cell is Blank - Delete Rows Based on Cell Value - Code Included

Поділитися
Вставка
  • Опубліковано 8 жов 2024
  • 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

КОМЕНТАРІ • 29