Hi,
I have a userform that will correctly place information into a total tab and another tab that uses an array formula to pull the information into the appropriate rows. I want to bypass the array formulas and have the userform search for the proper material and place the remaining information entered in the userform. I have used the find function to find the right row of the correct material but I have run into a wall trying to find the first empty row after the material row to place the data in the correct spot.

Private Sub cmdOK_Click()

Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("GRTotal")
Dim mRow As Long
Dim rRow As Long
Dim ws2 As Worksheet
Set ws2 = Worksheets("Bulk")

'find row of match of Material Description in Bulk tab
mRow = ws2.Cells.Find(what:=Me.MaterialDescriptionComboBox.Value, _
searchorder:=xlRows, searchdirection:=xlPrevious, LookIn:=xlValues).Row

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

From there I would simply place the remaining textbox values in the corresponding cell locations - i.e (rRow,16) etc.

Any help would be greatly appreciated.