- Joined
- Jan 29, 2018
- Messages
- 2
- Reaction score
- 0
I have a macro-loaded, full of cross-sheet reference workbook that is still a bit bigger than I would like it to be/feel it aught to be.
I also noticed that the scroll bar on the right of *one* of the worksheets indicates it scrolls a long way past the end of my filled cells in that sheet. So I naturally guessed that sheet might be the problem.
I hit Ctrl+End to find the last cell (N1048576 in this case) and selected all rows from there to the bottom of my data. I tried "clear all" and "delete rows", but in both cases, even when I save, close, and re-open excel the last active cell is still that one, and the document never gets any smaller.
Am I doing something wrong? Any idea what's going on here?
I also noticed that the scroll bar on the right of *one* of the worksheets indicates it scrolls a long way past the end of my filled cells in that sheet. So I naturally guessed that sheet might be the problem.
I hit Ctrl+End to find the last cell (N1048576 in this case) and selected all rows from there to the bottom of my data. I tried "clear all" and "delete rows", but in both cases, even when I save, close, and re-open excel the last active cell is still that one, and the document never gets any smaller.
Am I doing something wrong? Any idea what's going on here?