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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extra spaces at top of page 1
Changing header text from one page to another 1
Report to start Print at Bottom of a page instead of top of page 0
need macro to repeat two rows at top of each page 2
VB to get to top of page 2
INSERT A SYMBOL IN A CELL THAT TAKES ME BACK TO TOP OF PAGE 2
Eliminate blank row at top of Text Box entries 3
chart objects top 1

Back
Top