Question : delete rows in excel vba code
Answered by : attractive-anaconda-auyq8jrkli4a
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 : https://trumpexcel.com/vba-delete-row-excel/ | Last Update : Tue, 05 May 20