How can I insure that at the end of a macro the last row of data in the worksheet is visible at or near the bottom of the screen? The number of rows in the worksheet varies. If, for instance, there are 150 rows in a particular report, the selcted cell will be A150, but the screen shows rows 1-41, so A150 is not in view. I would like for A150 to be visible at or near the bottom of the screen when the macro finishes.

Thanks!

Tonso