Reduce Excel file size by reminding excel of last used cell

This reminds excel of the last used cell in a worksheet creating a smaller workbook file size.

Sub reset_last_cell ' fixes size problems of workbook by reminding excel what the last used cell is. Dim sh As Worksheet, x As Long For Each sh In ActiveWorkbook.Worksheets x = sh.UsedRange.Rows.Count Next sh End Sub

Code Snippits