Excel Used Range and Last Cell STILL Inaccurate
Posted on 2011-09-21
Cell IV65536 is registering as the last used cell in the range, which is obviously wrong for me. (It's just a few rows and columns of data.)
However, it obviously is making my file HUGE and SLOW!
I've tried deleteing the columns and rows around the data, using the Edit>Clear>All command, and even some VBAs in other solutions to clear up this mess.
BUT, still, nothing works (yes, I saved, closed, and re-opened the file only for it not to work still).
Any other ideas?