View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
macroapa macroapa is offline
external usenet poster
 
Posts: 14
Default moving to new cell and scrolling

Hi,

I want write some code that does the following:

Starting point would be in cell a1:-

1. move to cell a100
2. scroll window so that a100 is the top left visible cell

Clearly doing point 1 is easy, but how to I get the window to scroll
so that a100 is now at the top as opposed to the bottom?

Cheers.