Macro to navigate cursor
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
|