Macro to navigate cursor

[Kevryl]

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

[Harald Staff]

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

[Kevryl]

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
>
>
>

[Jean-Yves]

Hello,

Open VBA help and search for "Goto Method"
Regards
Jean-Yves

"Kevryl" <Kevryl@discussions.microsoft.com> wrote in message
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

[Kevryl]

Thanks Jean, you and Harald have both been very helpful.
Keith

"Jean-Yves" wrote:

> Hello,
>
> Open VBA help and search for "Goto Method"
> Regards
> Jean-Yves
>
> "Kevryl" <Kevryl@discussions.microsoft.com> wrote in message
> 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
>
>
>