| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to navigate cursor
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to navigate cursor
Hello,
Open VBA help and search for "Goto Method" Regards Jean-Yves "Kevryl" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to navigate cursor
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to navigate cursor
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving the cursor in a macro | Excel Discussion (Misc queries) | |||
| Navigate a worksheet when under control of a macro.... | Excel Programming | |||
| Navigate by macro | Excel Programming | |||
| Navigate by macro | Excel Programming | |||
| Macro to navigate between sheets | Excel Programming | |||
Linear Mode
