Automatically go to a certain cell
 

Hello,

is there a way, once asheet is opedned in excel, to move the cursor to the
botto mof the sheet?

For example, if I have data from row 1 through 100, when i open the sheet my
cursor would automatically go to the bottom at row 101. Then after I fill in
data for more rows, the cursor would autoamtically go to the next un-used row.

Is that possible?

Automatically go to a certain cell
 

Workook open event


Private Sub Workbook_Open()
Range("A65536").End(xlUp).Select
End Sub

You never said which column so A is assumed

Mike


"nabanco" wrote:

Hello,

is there a way, once asheet is opedned in excel, to move the cursor to the
botto mof the sheet?

For example, if I have data from row 1 through 100, when i open the sheet my
cursor would automatically go to the bottom at row 101. Then after I fill in
data for more rows, the cursor would autoamtically go to the next un-used row.

Is that possible?

Automatically go to a certain cell
 

Try this

Private Sub Workbook_Open()
Range("A65535").End(xlUp).Offset(1, 0).Activate
End Sub

"nabanco" wrote:

Hello,

is there a way, once asheet is opedned in excel, to move the cursor to the
botto mof the sheet?

For example, if I have data from row 1 through 100, when i open the sheet my
cursor would automatically go to the bottom at row 101. Then after I fill in
data for more rows, the cursor would autoamtically go to the next un-used row.

Is that possible?

Automatically go to a certain cell
 

Thanks Mike.

Yes, I am using column A. For some reason the code does not work. I pasted
it into "view code" and saved the sheet. When I go ito the sheet, the cursur
does not automatically go to the first cell in column A that does not have
typing in it.

Any ideas?

"Mike H" wrote:

Workook open event


Private Sub Workbook_Open()
Range("A65536").End(xlUp).Select
End Sub

You never said which column so A is assumed

Mike


"nabanco" wrote:

Hello,

is there a way, once asheet is opedned in excel, to move the cursor to the
botto mof the sheet?

For example, if I have data from row 1 through 100, when i open the sheet my
cursor would automatically go to the bottom at row 101. Then after I fill in
data for more rows, the cursor would autoamtically go to the next un-used row.

Is that possible?