[RESOLVED] Find next empty row, when data may/may not be in first column

[timh1234]

I am trying to write a code that pastes data entered into a Userform into the next empty row.

All is good, except for finding the empty row. Currently, I use the code:

emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1

But this only searches in column A for data. How do I find the empty row, when data could be entered into columns up to column Y (and beyond if possible)?

Thanks.