Data Import - Missing Text in Cell

[RU63]

I am looking for verification that a workbook in Excel 2003 is corrupt. If it isn't corrupt, I am hoping that someone can help me fix it.

Issue: I have a workbook that has about 10 sheets. I have a macro that imports data from the first sheet, to each of the remaining 9 sheets. This worked great for about a year. Now when I hit the macro, it imports only 255 characters into the destination cell, cutting off the rest of the text.

My own Diagnosis:* Excel doesn't realize that Text Wrap is on, and therefore only imports the maximum 255 characters, then turns Text Wrap on after the import.

*I have checked Validatoin, and there is no text limit. I have checked Text-Wrap and it is turned on.

Is this currupt?!!! or is there a setting I can hit to fix this.

Thanks

[Paul]

You may want to try uploading the workbook with some sample data in it that has the macro so we can see it in action.