View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Scroll filtered sheet to top

I am using Office 2003 on Windows XP.

I have a program that moves a user from one sheet to another, then filters
the destination sheet based on what the user clicked on the first sheet. The
destination sheet must have a frozen split screen turned on.

Depending upon where the cell pointer is, sometimes the visible rows are
scrolled out of view. I need a code string that will cause the view to scroll
all the way to the top so that all unfiltered rows are visible to the user.

Could someone please post example code to do this?

Thanks much in advance.