Cell Truncates to 255 characters in Macro
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 |
Cell Truncates to 255 characters in Macro
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 |
All times are GMT +1. The time now is 05:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com