row delete code example

Example 1: 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

Example 2: rows().remove

const table = $('#example').DataTable(); 
$('#example tbody').on( 'click', 'img.icon-delete', function () {    
  table
    .row( $(this).parents('tr') )
    .remove()
    .draw();
});