Suppose I have a worksheet active. At any given time, a certain set of rows
on the sheet are being displayed.

1) How would I have a VBA put the correct values in the variables
FirstRowBeingDisplayed as Long
LastRowBeingDisplayed as Long

2) The program terminates and the user is now in the direct mode. He is
free to move around in the worksheet. How might I set it up so that if his
moving around (with the arrow keys, mouse, or scroll bar, or whatever)
trggers a scrolling event, a subroutine Scroll_Routine is executed. )By
scrolling event I means an event which changes the set of cells displayed).
The first thing I want Scroll_Routine to do is to assign the correct values
to the variables FirstRowBeingDisplayed, LastRowBeingDisplayed,
FirstColBeingDisplayed, LastColBeingDisplayed.

Thank you




--
-regards