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?

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?
>

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?
>

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?
> >