Hello!
I need to search column "L" for the item code "126000" and then delete the entire row if that item number is present. Is there a faster way than I'm currently doing it (code below) as the spreadsheet has 15,000+ rows for it to iterate through.....
Is there a way to filter then delete then unfilter?
Sub DeleteRowWithCode()
Last = Cells(Rows.Count, "A").End(xlUp).Row
For i = Last To 1 Step -1
If (Cells(i, "L").Value) = "126000" Then
Cells(i, "A").EntireRow.Delete
End If
Next i
End Sub
Thank you!
I need to search column "L" for the item code "126000" and then delete the entire row if that item number is present. Is there a faster way than I'm currently doing it (code below) as the spreadsheet has 15,000+ rows for it to iterate through.....
Is there a way to filter then delete then unfilter?
Sub DeleteRowWithCode()
Last = Cells(Rows.Count, "A").End(xlUp).Row
For i = Last To 1 Step -1
If (Cells(i, "L").Value) = "126000" Then
Cells(i, "A").EntireRow.Delete
End If
Next i
End Sub
Thank you!