Thread: Copying Columns causes File Size to Explode

When I select a columns and then copy and paste them to another sheet, the file size grows tremendouslyl.

For instance, a 174 KB 4-worksheet file will grow to 6+ MB when I copy three of the sheets (column-by-column, but only half of the columns, however) to three new sheets in the same file. When I copy the three new sheets to a new workbook, the file size is just as big as the original (6+ MB).

When I select from top left corner to lower right corner of the used cells, the file size remains relatively small and reasonable (400 KB).

Can anyone tell me how to avoid this file size explosion and still do the copy process colum-by-column, because I need to copy the columns in a different order than they are on the original worksheet?

Regards,

Jim

use the microsoft excess formats cleaner add in. or just delete extra stuff see this describes both ways
http://support.microsoft.com/kb/244435

Thank you for the reply. I got the addin and it works great. I see that the project is not protected so I can change it so the message box does not execute and I can call the sub from my own code when needed.