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.
|