Scroll Into View

  • Thread starter Thread starter Peter M
  • Start date Start date
P

Peter M

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
 
With Activewindow
.ScrollRow = ActiveCell.Row
.ScrollColumn = ActiveCell.Column
End With
 
Back
Top