Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selection.sort process increase file size by 4.5mb
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File size increase | Excel Discussion (Misc queries) | |||
File size increase | Excel Discussion (Misc queries) | |||
Huge increase in file size | Excel Discussion (Misc queries) | |||
File Increase in size | Excel Discussion (Misc queries) | |||
File size increase | Excel Discussion (Misc queries) |