file size increases drmatically

[DaveL]

My file increases dramatically from 4 MB to almost 73 MB after I run my
macro. I've isolated the problem to the code inserting an additional row.
The command is "Rows(5).insert" . When I add or delete this command the size
of the file flucuates back and forth between 4 and 73 MB depending on whether
"Rows(5).Insert" is executed.

There is also a sort command before executing this command. I mention that
becasue I found someone that had a similar problem with "sort" doing
something similar. No one responded to his email or others with file size
increasing dramatically!

I'm running Excel 2007 but I recall having file size increases occuring on
excel 2003

Can someone from Excel help. Is there some way to research the problem
further.

Thanks

 

[Don Guillett]

If desired, send your file to my address below (small size pls) along with
explicit instructions on what makes it grow. I have 2003 and 2007 and will
take a look.