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

try wrapping the cell:
From the Main menu Select:

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

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Jerry" wrote:

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