(Solved) – VBA copy array of values to sheet. What is the max number of items

  • by
(solved)-–-vba-copy-array-of-values-to-sheet.-what-is-the-max-number-of-items

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.

Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *