Excel 2007 : Scroll with VBA to get active cell near top of window

[smooth]

If I activate a cell with VBA macro code, if the cell is already visible on screen, the window doesn't scroll at all. If the cell isn't currently visible, Excel scrolls the window so that the selected cell's row is roughly in the middle of the window. Is there any way to scroll the window with VBA code so that the selected cell is near the top of the window. I want as much of the text below the selected cell to be visible on screen as possible.

TIA.

[Andy Pope]

If you use,

Please Login or Register  to view this content.

The specified cell will be in top left corner.

[smooth]

That works perfectly. Thanks!