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)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Andrew" wrote in message om...
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