Excel VBA find empty row script error

[DcoltTech]

Hello there,

i ma currently building a user form for my project, and have a script that can find a blank row, where the data from text box one should be placed. When the script is run though, I get a 424 object required error. How can I fix this?

The code that I am using is:

eRow = Invoice.Cells(Rows.Count, 1).End(x1up).Offset(1, 0).Row
Cells(eRow, 1) = TextBox1.Text

Thanks in advance.

 

[VoG]

That shouldbe

eRow = Invoice.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

l not 1