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')

Code:
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