You can set the cell that you want in the upper left corner of the
ActiveWindow or the ActivePane with the following language:

ActiveWindow.ScrollRow = 10 €˜Row 10
ActiveWindow.ScrollColumn = 5 €˜Column E

Or:

ActiveWindow.Pane(2).ScrollRow = 10
ActiveWindow.Pane(2).ScrollColumn = 5

You would need to test the €œPane€� part because I am not too sure how it
would workin your specific worksheet.

tom