I created a macro that is used to update/add information to another separate
file. This saved file was getting to be rather large so I opened a new
workbook and copy/pasted each sheet into the new file. This reduced the size
by quite a bit, but once I ran the macro on this file again it jumped from
about 6.5M to 17.5M. Is there a way that I can prevent this? Maybe some kind
of code I can put into the macro that will get rid of what ever it is that is
increasing the file size? Thank you.