I constructed a large 2d array of strings in VBA Excel 10,000 by 26 (represent 10,000 rows and 26 columns) When I tried to copy the array into the worksheet range I got an error. When I reduced the rows to 2,000 everything work.
What is the limit, Items, size? can it be changed? Any workarounds? I did break the copy into 5 – 2,000 row copies which did work.