Thread: How to delete multiple rows on excel where the number in the first column is the same

Hi webuxer,

Which kind of information in a row will make that row eligible for deletion.. is it "Delivery Charge"in column F?

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Webuxer,

You can use following code to delete any row which has 3785 written anywhere :-

Sub del()
Cells(1, 1).Select
ActiveCell.EntireRow.Select
While ActiveCell.Value <> ""
    If Application.WorksheetFunction.CountIf(Selection, 3785) > 0 Then
    Selection.EntireRow.Delete
    Else
    Selection.Offset(1, 0).Select
    End If
Wend
End Sub

Regards,
DILIPandey

<click on below 'star' if this helps>