cant get it to work with deactivate-event, but activate seems ok if u can use
it

Private Sub Worksheet_Activate()
Application.Goto Reference:=Cells(Cells(65535, 1).End(xlUp).Row, 1),
scroll:=True
End Sub


"andy62" skrev:

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.