Runtime error '424' issue

[mmaeng13]

I am running into the runtime error '424' Object required issue. I am using the variable eRow in order to enter data from a userform into the next available row in a excel sheet. I can't find any issues with the code, it was working a couple weeks ago.

Here is a shortened version of what I am using.

Private Sub Enter_Click()


eRow = Database.Cells(Rows.Count, 1).End(x1Up).Offset(1, 0).Row


Cells(eRow, 1).Value = Day.Text
Cells(eRow, 2).Value = PMEHours.Text
Cells(eRow, 3).Value = PMEGallons.Text
Cells(eRow, 4).Value = SMEHours.Text


End Sub

 

[mmaeng13]

Edit: Maybe also if you change the red 1 in the lines below to a lower case L that it should be we might also get somewhere with one of the lines.

I don't know when or how that got changed but that is what it was. The file wasn't touched for almost 4 weeks and when I left it I was having zero issues with the data transferring as I needed it to.

Thank you.