Cell Truncates to 255 characters in Macro

[Andrew]

I am having a strange problem with cell truncation to 255 characters
when assigning value from one worksheet to another via a VB script. I
am using Excel 2002 SP2.

This is the portion within the case statement : R1, R0 and CO2 are
integers

Worksheets("Final").Cells(R1, 13).Value =
Worksheets("Import").Cells(R0, C02).Value

I need the cell in the Import worksheet imported into the Final
worksheet and the text there can range from a few sentences to one or
two paragraphs.

Anyone have any ideas?



Thanks in advance!


Andrew

 

[David McRitchie]

Hi Andrew,
Check your Excel Help (not VBA Help)
help, index, specifications

Column width
255 characters

Length of cell contents
(text) 32,767 characters.
Only 1,024 display in a cell;
all 32,767 display in the formula bar.

Turn on cell wrap (format, cell, alignment (tab), wrap cell)