I've created a user form where the data input goes to the next free row.

The problem I have is that at the end of the row I have a formula that will calculate some information set in the userform.

Is there a way to get the form to find the next "free row between cells A:N"? (as O:P have formulas to work out data entered in A:N)



Cross post -Original Post




Thanks guys, this is stumping me a lot.

code Im using for that bit is 

   RowCount = Worksheets("Sheet2").Range("A7").CurrentRegion.Rows.Count
    With Worksheets("Sheet2").Range("A7")
    .Offset(RowCount, 0).Value = Me.txtClaimnumber.Value
    .Offset(RowCount, 1).Value = Me.cboRTM.Value
    .Offset(RowCount, 2).Value = Me.cboassfrom.Value
    .Offset(RowCount, 3).Value = DateValue(Me.incidentdate.Value)
    .Offset(RowCount, 4).Value = DateValue(Me.fnoldate.Value) & " " & TimeValue(Me.fnoltime.Value)
    .Offset(RowCount, 5).Value = DateValue(Me.pickupdate.Value) & " " & TimeValue(Me.pickuptime.Value)
    .Offset(RowCount, 6).Value = Me.cboLiabfnol.Value
    .Offset(RowCount, 7).Value = Me.cboTelFnol.Value
    .Offset(RowCount, 8).Value = Me.cboAddressfnol.Value
    .Offset(RowCount, 9).Value = Me.cboLiabtriage.Value
    .Offset(RowCount, 10).Value = Me.cboaddresstriage.Value
    .Offset(RowCount, 11).Value = Me.cboNumbertriage.Value
    .Offset(RowCount, 12).Value = Me.cboassto.Value
    .Offset(RowCount, 13).Value = DateValue(Me.handoffdate.Value) & " " & TimeValue(Me.handofftime.Value)
    
End With