When Ctl-Home are depressed, the cursor moves to cell A1, and cell A1 i
moved to the very upper left-most corner of the screen. What cod
would be used to place the cursor to cell A55 and move it to the uppe
left-most corner

--
Message posted from http://www.ExcelForum.com

Sub testit()
Dim rng As Range

Set rng = Range("A55")
With ActiveWindow
.ScrollRow = rng.Row
.ScrollColumn = rng.Column
End With
End Sub

Rob


"pjhageman " wrote in message
...
When Ctl-Home are depressed, the cursor moves to cell A1, and cell A1 is
moved to the very upper left-most corner of the screen. What code
would be used to place the cursor to cell A55 and move it to the upper
left-most corner?


---
Message posted from http://www.ExcelForum.com/

One way:

Application.Goto _
Reference:=Range("A55"), _
Scroll:= True


In article ,
pjhageman wrote:

When Ctl-Home are depressed, the cursor moves to cell A1, and cell A1 is
moved to the very upper left-most corner of the screen. What code
would be used to place the cursor to cell A55 and move it to the upper
left-most corner?


---
Message posted from http://www.ExcelForum.com/

try

Application.Goto Worksheets("sheet10").Range("a55). Scroll:=True
for the active sheet just use
Application.Goto Range("a55"), Scroll:=True
--
Don Guillett
SalesAid Software

"pjhageman " wrote in message
...
When Ctl-Home are depressed, the cursor moves to cell A1, and cell A1 is
moved to the very upper left-most corner of the screen. What code
would be used to place the cursor to cell A55 and move it to the upper
left-most corner?


---
Message posted from http://www.ExcelForum.com/