Cell Truncates to 255 characters in Macro

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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
 
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)
 
Back
Top