Excel BIG File : 40Mb to 95Mb

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nader - 13 Jul 2007 09:35 GMT

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

Reply to this Message

Otto Moehrbach - 13 Jul 2007 22:21 GMT

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

> Hello,
>
[quoted text clipped - 8 lines]
>
> Nader

Reply to this Message