find last used cell in row in a table
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?
|