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

Scroll Into View
 

With Activewindow
.ScrollRow = ActiveCell.Row
.ScrollColumn = ActiveCell.Column
End With

--
Regards,
Tom Ogilvy


"Peter M" wrote in message
...
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