find last used cell in row in a table

[Jockster]

Sounds straightforward but it is giving me endless grief.
Using a userform and VBA, I need to figure out how to add data after the last cell which has data in it on a specific row.
So, for example, on row 10 of the attached, the last used cell in in "C" however, the last used cell in row 11 is "E"


Using the usual methods of finding the last column all seem to result in the last column of the table (in this case "F") and not the last cell in a row.

How can I get around this puzzle?

[excelledsoftware]

I found this trick a little bit ago and it has been amazing for finding the last row

FinalRow = Range("A50000").End(XlUp).Row + 2   'experiment what to add
'to make the last row you actually want get selected.

I tried this with your workbook and it appeared to work just fine but when you say the last row used you will need to change the number added on the end of the statement to get it to grab what you want. Also if your worksheet is longer than 50,000 rows just increase that amount in the range.

Let me know if that works

Thanks

[Jockster]

Thanks for replying.
This doesn't do what I was hoping for however, the following does so have managed to get around the issue:

LastColumn = Cells.Find(What:="", After:=ActiveCell.Offset(, 13), LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Select

Activecell.Offset (,13) - Active cell is the lookup value found in col "A" and the Offset part moves the start of the search area 13 columns away from the active cell; What:="" is searching for the first blank cell after col 13.