Return values from collection to worksheet

[tiredofit]

Normally when I use arrays, this can simply be returned in a single statement, such as:

Cells(1, 1).Resize(MyArrayRows, MyArrayCols).Value= MyArray()

If I were to use classes and collections to make my code easier to read, as per this article:

https://excelmacromastery.com/vba-class-modules/

I have got to the point where everything has been read into a collection and would like to return the results onto the worksheet.

Do I have to loop through each record to return the values?

Thanks

 

[RoryA]

Yes, you do.

 

[tiredofit]

So it's going to be a lot slower than arrays and therefore not advisable for large (a few hundred thousand rows) of data?

(I suppose I could create a new array, loop through the records of the collection into the array, then paste the array's contents in one line but that defeats the whole of NOT using arrays in the first place)!

 

[RoryA]

Not necessarily - you can still read the results into an array and use that to populate the sheet.

 

[tiredofit]

Thanks