Good Day,
I have an excel database that has records that have multiple rows. I want to search for the part number of the record using a userform and find the first available row to append data, from the rests of the userform, to the record. I have been able to find the correct row of the part number but when I try to search for the first blank row after that reference it does not work. I've attached a portion of the code below. Any ideas?


mRow = ws2.Cells.Find(what:=Me.MaterialDescriptionComboBox.Value, _
    searchorder:=xlRows, searchdirection:=xlPrevious, LookIn:=xlValues).Row + 2

rRow = ws2.Cells.Find(what:="*", after:=Cells(mRow, 1), searchorder:=xlRows, _
    searchdirection:=xlNext, LookIn:=xlValues).Row