🚀 go-pugleaf

I'm having a bit of a problem with an Excel macro, and I wonder if
someone can help.

The macro is really quite simple:  it opens a worksheet, selects all the
cells, formats the column width to "best fit," divides the spreadsheet so
that the first row and the first column are permanently displayed (the
first row contains column headings and the first column contains the
times at which the data were recorded), and scrolls down so that the last
row of the file was displayed.  

Now, the only way I know of to get to the last row is with "select last
cell."  The problem is that this always fouls up the row and column
heading display, scrolling both the "main" part of the spreadshet AND the
fenced-off row and column headings to the location of the last cell. 
This makes the macro essentially useless, because the user has no idea
what she's looking at if the row and column headings have disappeared.

How can I get to the last row (actually, anywhere on the last screen) of
the spreadsheet without fouling up the "divided" part of the spreadsheet?
___________________________________
William E. Williams, bwilliam@oyster.smcm.edu
Divison of Natural Sciences and Mathematics
St. Mary's College of Maryland
St. Mary's City, MD 20686