Sometimes tens of thousands of empty rows suddenly appear at the bottom of a worksheet thru no intentional action on my part. How can I eliminate them from the worksheet so that the vertical scroll bar resets its bottom limit to my intended bottom row.

Thanks,
Joe Miller