When I bring up Excel, the vertical scrollbar "knows" where the last row is
on the worksheet. Or, in other words, if I drag the scrollbar all the way to
the bottom, then the last row with data in it is also at the bottom. My
problem is the following:

Let's say I have 1000 filled rows. Then I delete the last 500 rows. The
vertical scrollbar when dragged to the bottom still thinks the bottom 500
rows are still there. The only way I can get the scrollbar to update is to
exit Excel and come back in. Since I am doing my deletions in VB, I would
like to get the scrollbar updated in VB also. However, I can't even do it
manually!!
Any thoughts??
thanks,
ken