View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default 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