View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andy62 andy62 is offline
external usenet poster
 
Posts: 158
Default Auto scroll down event

This should be easy, but I can't quite get it. I need an event macro that
will cause the current worksheet to "scroll down" to the end of the data set
before going to the other, selected worksheet. The data set is fixed, so I
could use something like "ActiveWindow.ScrollRow =", or "Application.Goto
Reference:=" to a name/bookmark. I tried to use those functions inside
"Private Sub WorkSheet_Deactivate()" but couldn't get it to work. Anyone?

TIA.