blankrow = cells(rows.count,"A").End(xlup).offset(1,0).row

uses column 1 to find the next blank cell. Adjust to suit.
--
Regards,
Tom Ogilvy


"MAWII" wrote:

I'm building a userform for test data entry that currently asks for 22 pieces
of information. I'm trying to take that information and enter it into the
next blank row in the spreadsheet. This seems like a rather basic task, but
I'm struggling. Please help! Thanks!

Mark