Hi, I have a spreadsheet with freeze panes set up pretty much in the middle
(so left and top stay constant as you scroll right or down)

I want to use a macro so that when triggered the right side of the screen
scrolls right to a certain column. Having done this, I notice that if you are
scrolled down, when you trigger the macro as well as scrolling right it also
scrolls back up to the top.

Anyone know how to get the macro to scroll right without changing the row?

I am using Excel 2000.

Thanks