Userform entering data in the last row instead of the first empty row from top.

[ibruzzi]

Hi everyone,

Can anybody tell me why my userform is adding values to the last row of the table instead of the first empty row from the top? And it keeps adding below the last added entry, shifting the added data up. This only happened when I converted the range into a table, before that it was fine.

 

[NoSparks]

without seeing your code, my guess is that you're determining the row to use by looking at a particular column with something like

RowToUse = cells(rows.count,"A").end(xlup).row + 1

which gives the bottom of the table + 1
try

RowToUse = Columns("A").cells.find(what:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).row + 1

which gives the last row used in the column + 1

 

[ibruzzi]

without seeing your code, my guess is that you're determining the row to use by looking at a particular column with something like

RowToUse = cells(rows.count,"A").end(xlup).row + 1

which gives the bottom of the table + 1
try

RowToUse = Columns("A").cells.find(what:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).row + 1

which gives the last row used in the column + 1

Thank you for the reply. Sorry for the late reply, I managed to find a workaround before this. Thank you ?