autofit doesn't work when new sheet created?

[trillium]

Hi

I have code that I've reused from another macro. I'm copying information from one tab, creating a new workbook, pasting in there, saving that new workbook and closing.

Within the course of the code, I also ensure that I autofit the rows so we can see all the text.

When I "watch" the code run, the autofit works. However, when the new Workbook saves and closes, the lines resize smaller?? This doesn't happen in the original code.. I run it and it works fine, the autofit stays.

I've tried placing the autofit code at different places.. nothing helps...

Hope you have some ideas!

Please Login or Register  to view this content.