Handling string in an array of length greater then 255 in excel

[LalitPandey87]

Hi All,


Today i found a situation when an array contains a string value which is greater then 255 char in length and when i use following code it gives me error (Run time error '1004')

Activesheet.range("A1").resize(ubound(arr), ubound(arr,2)) = arr

but if all values are less then 255 char in length it works fine.


so any suggestion to solve this kind of situation.


Thanks in Advance

In my case there is a particular value :-

e.g.:- "adadfadfad&adadfafa adfasfaf adsfasfasf fdsa&adfa's&adfadfafadfadfadfadf..."


which cause an error.