It depends on what you macro does, if it adds charts or stores a large array
or the like it can get rather large indeed, seeting all of the variables to
0 and the emptying arrays is always a good idea

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Rocks" wrote in message
...
Hello,
I recently was able to recover my Excel VBA Module from a corrupted Excel
File using OpenOffice Calc Application. After saving it back to an Excel
File I went back in and found every part of the File intact. I did notice
though that the size of the file was reduced in half, from 5.6 meg to 2.8
meg.
My question is,
Did my Code while running create all the extra size?
Is there a piece of code that I can append to the end of my program to
clean
up before exiting?

Thanks,
--
Rocks