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