Thanks Harald! Great stuff.
Keith

"Harald Staff" wrote:

Hi Keith

This code puts D15 in the upper left side of the scrollable area and selects
E16:

Sub GoThere()
ActiveWindow.ScrollRow = 15
ActiveWindow.ScrollColumn = 4
Range("E16").Select
End Sub

Scrollable area is the spreadsheet itself unless you freeze rows/columns.

HTH. Best wishes Harald

"Kevryl" skrev i melding
...
I frequently use macros to move cursor to a specific column, but haven't
worked out how to reliably set the screen so the destination column with
the
cursor appears on the left hand side of the screen. Sometimes specifying a
row way off-screen to the right and coming back to the column works, but
its
clumsy and unreliable. Any ideas?
Thanks
Keith