load/parse large text file
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
|