Spreadsheet opens different row

  • Thread starter Thread starter Gary Elsner
  • Start date Start date
G

Gary Elsner

I use a lot of very large spreadsheets, and it used to be
that when I opened one, it would open with the last row
that I had viewed.

Now when I open them they often open showing the top row.

How do I change it back so that they open with the last
row viewed?

I tried saving the spreadsheet with the last row viewed
showing, but this does not seem to help.

It would save a lot of time, if you can help me determine
how to do this.

Thanks very much,

/ Gary E.
 
Paul,

I've tried saving it when viewing one of the last rows,
and it still opens with the first row showing.

It doesn't have any special events that address the
opening of the spreadsheet.

Any other ideas or even experiments I could run to see if
they will work?

Thanks,

/ Gary E.
 
Paul or others,

See below...what code can I add in the open event to have
it open displaying the last row?

Thanks,

/ Gary E.
 
Gary, you could put this in the open event, it will select the last row in
column A with data in it when the workbook is opened

Private Sub Workbook_Open()
Range("A65536").End(xlUp).Select
End Sub
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top