View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default vba- go to top of page

Application.goto _
Reference:=Activesheet.Range("A1"), Scroll:=True

--
Regards,
Tom Ogilvy


chick-racer wrote in message
...

I'm just curious to know if there is a line of code i can add that will
make the spreadsheet go to the top of the page (the beginning).
I have alot of subroutines and after they execute, the page displays
700 rows down from the top.

thankya.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements