vba- go to top of page

  • Thread starter Thread starter chick-racer
  • Start date Start date
C

chick-racer

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

thankya
 
i've actually tried that, and variations of it.
It does select the cell, but it doesnt take the display (my view of the
page) back up to the top.
thank you though.
any more suggestions???? :)
 
chick-racer,

Try one of these......
From Harlan:

Range("A1").Select
Application.Goto ActiveCell, True

or from Chrissy:

ActiveWindow.ScrollColumn = Range("A1").Column
ActiveWindow.ScrollRow = Range("A1").Row

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

--
Regards,
Tom Ogilvy


chick-racer said:
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.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top