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.

[Rick Rothstein]

In my case there is a particular value :-

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


which cause an error.

It might help us to help you if you attached a copy of your workbook with its data and your existing code so that we could see exactly what you see.