| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.Value2 is failing for lenghty strings
Hi,
I am trying to assign values to range using an array, however, it is failing when one of the cell values are going beyone 930+ chars. I have the below code trying to assign an DataTable itemarray to the range... //insertRange is an Excel.Range object insertRange.Value2 = _myDataTable.Rows[i].ItemArray; The above code is working fine as long as the itemArray contains values less than 930 characters ( I have not really arrived at the number exactly when it is failing). Can you please let me know why Value2 property is failing in this long string case? or how can I set the length of the cell/listColumn? Please help. Thanks, Naresh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not finding value, range method failing | Excel Programming | |||
| changelink with the name and new name as strings is failing | Excel Programming | |||
| select method of range class failing ? | Excel Programming | |||
| Lookup Value2 | Excel Programming | |||
| Activecell.value or value2? | Excel Programming | |||
Threaded Mode
