How to find the last row in a table ,from bottoms to the last cell

[kvemperor]

I know the code how to find the last row in a table. If for example I have a table and the the table starts from A5 (for example) the code will be...
Range("A5").End(xlDown).Offset(1, 0).Select
But if I have blank cells in the table ,running this code i will go at the first blank cell,and not at the bottom of the table.
Is there a code that starts from the last cell of the bottom of excel and goes all the way up to the last cell of the table?
Thank you in advance

[TMS]

Try

Please Login or Register  to view this content.

[kvemperor]

it worked perfectly.thank you very much

[TMS]

You're welcome. Thanks for the rep.

[Marc L]

Hello,

as a reminder if it is a true Excel table then using a specific code to find the last row is useless at it is already embedded within the table …

[kvemperor]

Hello,

as a reminder if it is a true Excel table then using a specific code to find the last row is useless at it is already embedded within the table …

what do you mean by that?i already use this code with a button.
is there an other way with the same results?

[Marc L]

As it depends on the missing answer to my previous post or just attach your workbook with your best elaboration …

[kvemperor]

As it depends on the missing answer to my previous post or just attach your workbook with your best elaboration …

one of my workbooks that i am using it

[Marc L]

TMS' post #2 already answers whatever if the column has an Excel table or not …

Anyway according to your attachment where you use two Excel tables then based on the Excel Objects Model
this VBA procedure can replace your both procedures if associated to each 'LASTROW' button :

Please Login or Register  to view this content.

[kvemperor]

TMS' post #2 already answers whatever if the column has an Excel table or not …

Anyway according to your attachment where you use two Excel tables then based on the Excel Objects Model
this VBA procedure can replace your both procedures if associated to each 'LASTROW' button :

Please Login or Register  to view this content.

Hallo from Greece. first of all thank you very much for all your effort. The code you gave me goes at the last row of the first table when i run it. i can see you are very expert .do you think is there a way to make my sheet pore productive?this is my inventory of my 2 shops

[Marc L]

Aloha !

According to your attachment it depends on which button launches my VBA procedure.
I can't tell anything about your worksheet, maybe TMS could …