We have a spreadsheet of 3922 rows that has somehow expanded to include thousands of blank, unused rows with formulas, rendering the spreadsheet almost unusable. The active spreadsheet is from A1 to FA3922, but when I hit CTRL-END, the last cell is now FA1048576. Due to the complexity of conditional formatting, formulas, etc. I don't want to risk copying the data to a new spreadsheet. Instead, I wondered if:
1. Is there a macro or VBA that can be implemented to delete rows 3923 to 1048576.
2. Is there a way to set the maximum number of rows in a spreadsheet to 5000?