Solved: Bringing a selected cell to the top of the screen

[JohnERP]

Goal: Find and present in the active window, automatially, a particular cell in a worksheet.

Currently, on a Before Double Click, I have some code that finds the original source (meaning worksheet and cell) of the value from my target cell (which is generally in a different worksheet). Although I can Select the source cell, it doesn't come into focus on the source work sheet window because there could be thousands of rows of data. What syntax/functions can I use to bring the cell (by scrolling or whatever means) into the active window? Right now the user has to scroll around and hope to see the cell in focus.

Any tips are welcome!

[mikerickson]

Application.Goto Reference:=Range("AA108")

will put AA108 on the screen. Which edge or corner of the screen will depend on what is on the screen before that line runs.

[mdmackillop]

[VBA]ActiveWindow.Scrollrow = 10[/VBA]

[JohnERP]

Thanks for the help!

[JohnERP]

Works great. I completely missed this in my books.
Thanks