Macro performance

J

John

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Menu Macro Not Executing - Need Help 1
Can you freeze one side of the Excel window so the other side stay 1
How do I lock a section of cells in place 1
Macro to Select text from a point given to a specific word 2
Unable to freeze panes 15
How to insert border around text in footer dynamically in excel? 1
Macro attached to Autoshape Hyperlink not invoking 0

Top