vba- go to top of page
 

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

-----------------------------------------------
~~ 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

vba- go to top of page
 

Range("A1").Select

vba- go to top of page
 

chick-racer,

Range("A1").Select

John

chick-racer wrote:

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

vba- go to top of page
 

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


------------------------------------------------
~~ 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

vba- go to top of page
 

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

chick-racer wrote:

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

------------------------------------------------
~~ 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

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