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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
worksheet.copy truncates at 255 characters 3
Worksheet.Copy() truncates cell contents problem 3
Trouble with 255 characters max in a cell 3
copying cells with more then 255 characters to new workbook 4
How to find row with more than 255 characters in a cell 4
Excel Data Truncated to 255 Characters 0
Truncate Left Characters in Cell Value 4

Back
Top