Hi

I want to copy the formula in column "C" to each row, and change the row number each time i add a new row with data. Anyone know how to do this?

I know this won't work, but this is so that you may better understand what I want.

With ws
  .Cells(lRow, 1).Value = Me.txtbxQty.value
  .Cells(lRow, 2).Value = Me.txtbxCur.value
'This is where I need help
  .Cells(lRow, 3).Value = "=a2*b2"
End With