Hello !

Im having problem moving an array that contains a lot of data to an excell-sheet. In the code below I have an example, I collect data from a sheet cell A1 and A2 and put it in the string StringInput and then I want to put the array in cell B1 and C1. This works fine if the content of cell A1 and A2 is less than 910 characters but if it is larger i get "Run-time error 1004 Application-defined or object-defined error"

It works if I use Sheet1.range("B1")=StringInput(0) no problem even if A1 is larger than 910 characters, what is the diffrens and why cant i copy the whole array at once?

In my real application I have a very large array and it takes to much time to move the data one cell at the time.

Anyone have som ideas?


Sub test()

Dim StringInput(1) As String

StringInput(0) = Sheet1.Range("A1")
StringInput(1) = Sheet1.Range("A2")

Sheet1.Range("B1:C1") = StringInput()

End Sub


Thanks //Jonas