ExcelBanter - Scroll a cell to the top left hand corner of the screen

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Scroll a cell to the top left hand corner of the screen (https://www.excelbanter.com/excel-discussion-misc-queries/107686-scroll-cell-top-left-hand-corner-screen.html)

Daveh

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

Dave Peterson

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

Daveh

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

All times are GMT +1. The time now is 11:33 AM.