selection.sort process increase file size by 4.5mb

W

Warren

Hi
Currently have a large file of 47.9mb after using a macro with a
selection.sort as shown below the file increases by about 4.5mb to 54mb. The
sort only sorts the data. Does excel 2003 do something hind the scenes after
the sort process. I can save the file. closed it, reopen it, resave and the
file returns back to 47.9mb.

Main issue im required to save file on a work pc which operates on excel
2003 the file must remain under approx 52-53 mb.

Thanks for your advice.

Regards Warren

Code

Sheets("Team Data").Select
Range("A5:BK300").Select
Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Range("A5").Select
Sheets("Input").Select
Range("C5:GF300").Select
Selection.Sort Key1:=Range("FI5"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 1004 Application-defined or object defined error" on data sort 1
Code to sort rows getting hung up by merged cells 0
clearing excel memory before saving 0
Simple Do... Until problem 4
SpecialCells(xlCellTypeBlanks) = error 1004 No cells found 5
Error Message: Sort Method of Range Class Failed 2
Sorting Macro Loop 2
Sort in hidden page crach 8

Top