usedrange doesn't reset when using 'application.activesheet.usedrange'

hi guys and girls,

the usedrange in my workbook is currently listed as $A$1:$FM$7729 for reasons unknown to me, as the last cell on sheet is $EJ$42 (according to debug.Print activesheet.cells.find(what:="*", searchdirection:=xlprevious).address)

Normally, I can 'reset' the usedrange by simply typing application.activesheet.usedrange in the direct window, but on this workbook, it doesn't do anything.
And I don't get why

You might wonder why I think this is important - currently it is a 4MB workbook as it's saving the sheet with A1:FM7229, while it should just be saving A1:EJ42. Quite the difference in file size, I expect.

I tried saving as xlsb for a while and while that greatly decreases filesize, it sometimes corrupts the workbook for no reason (that's a question for another thread ).

So - does anyone have any idea how to make excel realize the sheet is quite a bit smaller than it thinks it is?
Many thanks in advance!

Jasper

OK, I solved it thanks to this thread

I had to delete all conditional formatting, delete all rows and columns outside of $A$1:$EJ$42 and then used 'application.activesheet.usedrange' again.
I don't understand why, but it worked.
Props to TMS in the other thread for pointing me in the right direction.

Here is another thread to keep in mind Jasper.
http://www.mrexcel.com/forum/excel-q...iece-code.html