Hi all

I have created a spreadsheet (xl97) using formulas, userforms and some
buttons spanning approx 7 worksheets. While new to vb, it's size seemed a
little large (740kb) and so I have done some investigating.

I first deleted the contents of module1 which decreased the file size to
624kb. I then progressively deleted all the worksheet contents (saving as I
went) until I got down to one worksheet and one with a number of charts on.
The filesize had progressively decreased to 382KB.

I then deleted my (empty) module1 and the filesize reduced to 93KB when
saved. Thats nearly 300KB stored in an empty module1. Can anyone shed some
light on the space waster for me.

Thanks
Tony.

Hi Mcpheat,

I then deleted my (empty) module1 and the filesize reduced to 93KB when
saved. Thats nearly 300KB stored in an empty module1. Can anyone shed some
light on the space waster for me.


The VBE does a bad job cleaning up code that has been heavily edited. Much
of the stuff you changed/removed remains behind in the file somewhere.
That is why Rob Bovey has created his highly recommended Code Cleaner. Find
it at www.appspro.com or at www.bmsltd.ie/mvp

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com