Bizarre VBA Looping issue...

Hi there,

I have written a macro that copies cells in a column of spreadsheet (A) into a column in spreadsheet (B) and then saves off a copy of spreadsheet (A) and moves onto the next column in spreadsheet (B) and repeats the process.

Everythign works fine except for one thing - Each iteration of the loop increases in file size by about 50 kb. If I have 56 iterations, the last spreadsheets that are created have huge file sizes even though they are no different in appearance from the first spreadsheet.

The weird thing is this: If i open the workbook and save it again, the file size reduces to the original size - 400kb. Does anybody know where this phantom file size increase is coming from?

(I have set cutcopymode to false, btw)

Additionally, I clear out all the changing cells in spreadsheet (a) before filling them in with cells from the next column in (B).


Does anybody know why the file size would increase? Is there some history thats being captured by any chance?