Hi Peter,

I have to confess I only scan read parts of the thread before posting the
previous two times, eg I didn't pick up on "this method" in your adjacent
post

I see your point, for me in a very light test the array to cells method
truncates to 1823 characters

[a1].Formula = "=Rept(""a"", 20000)"
[a1:d5] = [a1].Value

varr = [a1:d5].Value
Debug.Print Len(varr(2, 2)) ' 20000, picks up fine

Range("A11:d16") = varr
Debug.Print Len(Range("A11")) ' 1823, dumps truncated

Regards,
Peter T


"Peter Grebenik" wrote in message
oups.com...
Peter

I was merely pointing out the limitations of copying data by setting a
range equal to an array. It means that this method cannot be used to
copy cells containing very long text strings; they have to be copied
using the copy method.

Peter