PDA

View Full Version : Excel file doubles in size



lougo2
08-09-2007, 08:26 AM
Whenever I save my Excel / VBA project uder a new file name, it doubles in size. I can't figure out whats going on. Help!

Lou

rory
08-09-2007, 08:41 AM
Anything in the beforesave event?

lougo2
08-09-2007, 08:52 AM
Thanks for your quick responce.
I have not use the beforesave event in the program.
basic spreadsheet with a few userforms including a flexgrid which is filled from an array.
lou

rory
08-09-2007, 09:09 AM
Have you tried exporting the userforms and any code modules, deleting them and then reimporting them? This serves to clean out any bloat that occurs as you edit them.
If you are not editing them, then check that pressing Ctrl+End in any worksheet takes you to what should be the last data cell.