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

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