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

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DaveL" wrote in message
...
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