View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Cell A1 in Upper Left Corner

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/