Focus on Last Row

I have the following code:

Please Login or Register  to view this content.

and I would like when the Command Button is clicked for the DATABASE sheet to show with the focus on the last row. I thought

Sheets("DATABASE").Cells(lastrow).Show

would do it, but apparently not.

You could try:

Please Login or Register  to view this content.

The "1" being the number of one of your columns.

Originally Posted by millz

Try:

Please Login or Register  to view this content.

Edit: you can try with this if you want the focus to be somewhere in the middle (vertically) of the screen

Please Login or Register  to view this content.

Worked perfectly! Thank you so much.