Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba- go to top of page
Range("A1").Select
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel 2010 files as web page or single file web page | Excel Discussion (Misc queries) | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Add page numbers to multiple worksheets without changing page setu | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) |