View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter M[_3_] Peter M[_3_] is offline
external usenet poster
 
Posts: 18
Default Scroll Into View

I have a set of macro's that select a predefined cell. Although the cells
are correctly selected I wish to make the newly selected cell move to the
top left hand corner of the window. The ActiveWindow.ScrollIntoView command
seems ideal, I can use the top, left, width and height properties of the
range object to indicate what I want at the top left.

However it doesnt seem to work, the command executes without errror, but the
cell is often placed only half way up the screen? Is there a margin or some
other setting I have ignored?

Grateful for any advice.

Thanks,

Peter M