What is the most efficient/quickest way to loop through rows in VBA (excel)? - Stack Overflow
If you are just looping through 10k rows in column A, then dump the row into a variant array and then loop through that. You can then either add the elements to a new array (while adding rows when needed) and using Transpose() to put the array onto your r...