I have sorted rows for which I need to strip off all rows that do not begin with a "0". I was hoping to try and find the first row where the part number begins with "IN" and then I would delete all the row from there to the end. The problem I am having is that the Match function works great if you know the first part number that it would find that matches. I was hoping to find the first part number with "IN" using match but I think maybe I am going about it the wrong way. I realize it is not robust but I can't think of a way to delete all rows that don't have a part number starting with a "0" without cycling through and evaluating all the records. Any help appreciated.



Dim x As Integer
Sheets("MRPwo").Select
x = Application.WorksheetFunction.Match("IN00010", Worksheets("MRPwo").Range("A:A"), 0)