Your code is probably initializing cells that end up by not being used. They
have the overhad of any other cell, they just happen to be blank. This is
common if you hard code ranges into your macro. Take a look at the sheets
after your macro is done. Do the scroll bars allow you to move well beyond
the range of cells with values int them? If so all of the cells that you are
seeing beyond the last row and column of data need to be deleted. You are
best off to avoid creating these cells in the first place. To make the file
small again, delete (not clear contents) all of the blank rows at the bottom
and all of the blank column to the right. Now when you save your file you
should notice that it goes back to being small again...
--
HTH...

Jim Thomlinson


"BigPig" wrote:

Why would a worksheet that is normally 57 kb turn into 500kb after using
macros to enter data into it?

Example: I have a workbook that has a database in it, and a userform that
takes that data based on ssn's and places that specific data in appropriate
places in a spreadsheet that is made to look like a form. Then the user uses
a commmand button/macro to save the 'form' with the data in it, to a separate
folder. The new file is now 500 plus kbs.

I even went so far as to delete all the data, lines etc... and the file size
changed to 475 kb. Not a lot different.

Is there another solution to this file size dilemna?

Thankyou.