vba- go to top of page

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
 
C

chick-racer

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???? :)
 
J

John Wilson

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
 
T

Tom Ogilvy

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.
Click to expand...
creating financial statements
 
Top