Lost partial contents in one cell when copy a sheet to other workb

J

Jerry

Hi,

I need copy a sheet from a template workbook to a large batch of workbooks.
After copy using VBA, one merged cell, which has only plain text, lost some
contents in target workbooks, with only 255 characters left. How to fix it?

is this because cell format? Data type in that cell, i chose "general". if i
do use "Text", the cell displays ###################.

I'd appreciate it.
Jerry
 
M

Michael

try wrapping the cell:
From the Main menu Select:

Forma -> Cells
In the Alignment Tab click on the Wrap Text box
 
Top