Somehow I got the whole spreadsheet picked up when I use Ctrl+End to go to the end of the active cells. This is creating a spreadsheet size of about 20Meg when it should be about 5Meg. I can't find out how to fix it so the actual active range is around A1:CN706. Can someone help as I do not want to have to redo the whole worksheet as it has a lot of macros tied to it I'd prefer not to have to revise (I'm VBA challenged) .
Bookmarks