Thread: Writing to xls form vba array - see also populating VBA array to xls

Dear all,

I need to write all the values of a large 2D VBA array to cell a1 in xls.
The thing is that this needs to be done in successive iterations - i.e. Assuming the VBA array contains 1 mio numbers ranging from 1 to 300, i need a1 populated with numbers from 1 to 300 a million times.

Thank you all for yuor help.

Best regards, z

arrays do have size limits below 300million
what are you trying to do?