I am trying to use an array to populate a column of around 300,000 rows. The routine gives N/A after 30,000 (10% of what I want). What's the maximum number of elements for an array (to simplify it let's say one dimension - redim arr(1 to bigNum) in excel 2016? How can I get it to work? I can't use loops to populate as it's taking way long. Any help appreciated!