I have a button would like to do the followings:
User click the button, I want to make a cell to be selected(make it focused)
in a row which is the last row. This last row is not the last row of the
worksheet but the last row of the column who has no value ?

For example:

A B C
Peter 25 11:35pm
John 33 12pm
Mary 23 1:22am

So if the user click the button, the cell A4 should be selected. I want to
simulate as a new record function.

Range("A" & Rows.Count).End(xlUp).Offset(1).Select

--

Vasant

"Man Utd" wrote in message
...
I have a button would like to do the followings:
User click the button, I want to make a cell to be selected(make it
focused)
in a row which is the last row. This last row is not the last row of the
worksheet but the last row of the column who has no value ?

For example:

A B C
Peter 25 11:35pm
John 33 12pm
Mary 23 1:22am

So if the user click the button, the cell A4 should be selected. I want to
simulate as a new record function.

Thank you for your reply.
I tried, it seems have strange behaviour to my case:

I have defined 100 rows in which 2 columns have formula inside, and their
contents are empty. When I run this code, the cell selected is the cell
A101but not A1.


Range("A" & Rows.Count).End(xlUp).Offset(1).Select