Macros interupted by excel events...

I have just created a macro that formulates a market
profile for certain stocks. I use about 8 worksheets
to produce a daily and weekly report, when I finish
cut and pasting the values into my report using special
paste, values I then want to delete the old worksheets
which contain all of my formulas, etc. This is done also
because when I go to save the workbook after the macro
has been run, its size has been increased from a humble
130 kb to 14Mb!!!
Any other sugestions would be appreciated.

Thanks Todd.