Naresh,
XL2K, this works:
ActiveCell.Value2 = String(1000, "c")
MsgBox Len(ActiveCell.Value2)

Maybe the problem is with the source of your data rather than Excel ?

NickHK

"Naresh Mirkhelkar" wrote in
message ...
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...[i]

//insertRange is an Excel.Range object
insertRange.Value2 = _myDataTable.Rows.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