Delete rows in excel vba code

Sub DeleteRowswithSpecificValue()
For i = Selection.Rows.Count To 1 Step -1
If Cells(i, 2).Value = "Printer" Then
Cells(i, 2).EntireRow.Delete
End If
Next i
End Sub

Source: trumpexcel.com

Similar codes

0 vote126 views1 answer
Test if form is open vb
VBA
0 vote140 views1 answer
Vba listbox remove all items
VBA
0 vote131 views1 answer
Vba integer to double
VBA
0 vote125 views1 answer
Excel vba hide columns
VBA
0 vote120 views1 answer
Vba word pdf table to excel
VBA
1 vote120 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote83 views1 answer
Excel vba arrondir
VBA
1 vote140 views1 answer
Excel vba autofit
VBA
0 vote125 views1 answer
How to extract a file from an ISO:
VBA
0 vote138 views1 answer
Vba array dimensions
VBA