Excel BIG File : 40Mb to 95Mb

[Nader]

Hello,

I have a done a sort thru vba and my excel sheet which was orginally 40Mb
became after the sort 95Mb. What is the reason of that increase by double of
the size ?

Thanks in advance.

Regards,

Nader

 

[Otto Moehrbach]

In each sheet do Ctrl - End. This will take you to what Excel thinks is the
last cell in the used range. Compare that cell's location to what you know
to be the last cell in the used range. A large difference in location of
those two cells could explain the problem. Post back with what you find.
HTH Otto