Delete rows based on value/text // Excel VBA Tutorial

In this video I show you how to delete rows based on a value or text. The code is as follows:
Under delete_rows()

For i 2 TB Sheets(2).UsedRange.Rows.Count
If Cells(i, 3).Value /"No/" Then
Rows(i).EntireRow.Delete
End if
If Cells(i, 3).Value /"No/" Then
Rows(i).EntireRow.Delete
End if
Then I

End of the submarine

Please take the opportunity to connect and share this video with your friends and family if you find it useful.