I have built a form that shows data for two different years, but the spreadsheet is too big to fit the screen. I have columns A and B frozen because they contain row headers. I want to be able to make a button that slides the spreadsheet over perfectly to show the 09 data. I do not want to hide because the user will want to slide back and forth and will be anoyed if they have to unhide everytime.

I have tried some things and the problem I have had is if I record myself sliding, it does not work at different %-zoom levels, and if I have already slid part way and push my button, it slides to far.

Any thoughts?