| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scroll a cell to the top left hand corner of the screen
I want to be able to scroll a cell range to the top left hand corner of the
screen under macro control; just as Ctrl + Home does for cell A1. Any ideas ?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Scroll a cell to the top left hand corner of the screen
How about this?
Option Explicit Sub testme() Dim myRng As Range Set myRng = Worksheets("sheet2").Range("C3:d99") Application.Goto myRng, scroll:=True 'or 'Application.Goto myRng.Cells(1), scroll:=True End Sub Daveh wrote: I want to be able to scroll a cell range to the top left hand corner of the screen under macro control; just as Ctrl + Home does for cell A1. Any ideas ?? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Scroll a cell to the top left hand corner of the screen
Thanks, just what I wanted !
"Dave Peterson" wrote: How about this? Option Explicit Sub testme() Dim myRng As Range Set myRng = Worksheets("sheet2").Range("C3:d99") Application.Goto myRng, scroll:=True 'or 'Application.Goto myRng.Cells(1), scroll:=True End Sub Daveh wrote: I want to be able to scroll a cell range to the top left hand corner of the screen under macro control; just as Ctrl + Home does for cell A1. Any ideas ?? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| How do I move the current cell to the top of the screen? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
