Open WorkSheet to last data entry

Have a look at the second section on this page.

http://www.cpearson.com/excel/zoom.htm

Was not sure how to make them codes work,everything I tried failed.Here is a sample of what I'm looking for,what the sheet to open to last entry in center of page if possible.When the sheet changes it does a auto sort.

This seems to work,not sure if right but will use for now.

Please Login or Register  to view this content.

If it does what you need then nothing wrong with it.

The code in the link I provided goes a bit further by counting the number of rows / columns that will fit on your screen to make the position more exact, if for example you sent it to someone else who has a different screen resolution, but if you don't need that sort of precision then what you have should be fine.