Hi all,
I'm reading a CSV file from a shared folder into a string, which I then split on vblf (chr(10)), simply by
The resulting array has 69,118 rows, with each 15 columns of data. Going into the locals window, I can see that all elements of my 1D array have data (up until the last one).Please Login or Register to view this content.
Now I want to paste this into Sheet1 by saying:
Resulting output is that I get 3583 rows with data, and 65535 rows with #N/APlease Login or Register to view this content.
I SUSPECT it is due to "If you try and transpose an array that contains more than 65535 (2^16) elements then you receive a type mismatch", as detailed here: https://bettersolutions.com/vba/arrays/transposing.htm
Pasting it to the sheet line by line is really slow, and writing to drive and then opening the file as csv, subsequently copying/pasting the range defeats the purpose.
So, what's the quickest way to get the delimited string onto my sheet...?
Any help is appreciated.
Bookmarks