Userform on last row of column A

[IKZOUHETNIETWETEN]

I want my userform in the last row of column A, but its now searching for the last empty row of all columns, kinda annoying because I have formulas in column H that calculates with data from the userform.
Just click the macro button and the userform pops up and add by pressing 'Toevoegen'. Any can help me out so the userform is being put in row 6 and not row 29 ? Thanks!

map3.xlsm

[alansidman]

I think that you had some data in Row 28 and instead of deleting the rows you just cleared them of data. Try highlighting rows 6 to 30 and right clicking to delete. When I did that, it put data in the proper location.

[jet2004uk]

Seems to be linked to the Table that you have, where ever you move your Table Row to then the data inputs under that row, moved your Table up to row 6 and data then inserts in next avaible row

[IKZOUHETNIETWETEN]

No, the reason why my userform data will be put in row 28 is because I have a formula in H28. The userform macro code read the last empty ROW. But I want ti look for the last empty row in column A and not the entire Row. Column H needs to have the formula. So plz give me a code so its gna paste it right under row 5

[IKZOUHETNIETWETEN]

Please Login or Register  to view this content.

Thats the code right now by the way

[IKZOUHETNIETWETEN]

Ok got it, its working now:

Please Login or Register  to view this content.

[IKZOUHETNIETWETEN]

Mm no wait, its not working lol, its getting now the latest row of a column, i want the rest to be next to my value in column A on the same row.. how?

map3.xlsm