Thread: Scroll the window to the top - frozen rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ivan F Moala[_28_] Ivan F Moala[_28_] is offline
external usenet poster
  
Posts: 1
Default Scroll the window to the top - frozen rows

you could try

Application.Goto [A4], True

where A4 is the cell below your frozen row pane.

Look up the [Goto Method] in your VBA Help files for more info

--
Ivan F Moal

-----------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195
View this thread: http://www.excelforum.com/showthread.php?threadid=26968

Reply With QuoteReply With Quote