Select first table cell with data and offset

[Undo]

Hey

Within "Sheet1" "Table1"

I want VBA code to select first cell with data from the bottom of the table in coulmn name "Number"
Then offset one cell down

Thanks

[sintek]

If you are using the List Object correctly then this will take you 1 row below the actual Table...
Unless you are making the common mistake of having lots and lots of blank rows within said Table...
Attath sample file for accurate feedback...

[Undo]

yes I know this point, the code will be fine

[sintek]

Please Login or Register  to view this content.

[Undo]

Thanks but the code didnt work like I ask
It should stop in yellow cell
explain again : column Number : calculate from bottom of the table > select first non blank cell ( F6 ) then go one cell down ( F7 )

[sintek]

Yep classic error...why oh why the blank rows in table????

[Undo]

My working will be like that, table will be like that
any other code to select same cell?

[Undo]

I am not a pro in coding but with this steps we can go?
select last cell in table column Number
then xlup,now we are in last nonblank cell, then offset one cell down

[Akuini]

Try:

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.

[Undo]

Thanks All!

sintek : Exactly!
Akuini : Second code working!

[sintek]

All good...tx for rep +