VBA Code to Delete Row Based on Criteria in Excel

This code deletes rows in the selected range that meet a specific criteria.

VBA Code:

Sub DeleteRowBasedOnCriteria()
    Dim cell As Range
    
    For Each cell In Selection
        If cell.Value = "Criteria" Then
            cell.EntireRow.Delete
        End If
    Next cell
End Sub

Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment