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" <Kevryl@discussions.microsoft.com> skrev i melding
news:50005737-E2E7-4509-9CD3-B23D9347063D@microsoft.com...
> 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

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" <Kevryl@discussions.microsoft.com> skrev i melding
> news:50005737-E2E7-4509-9CD3-B23D9347063D@microsoft.com...
> > 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
>
>
>