View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Lost partial contents in one cell when copy a sheet to other workb

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