Fastest way to record temporary data results for analysis

[stockgoblin42]

Hi,

I'm looping through a data set and retrieving about 100 results of 5 numbers. Now, as each result is gained, I insert a space to a seperate sheet, copy the five numbers and then return to the loop to get the next positive result. After the loops have finished going through the data set, I copy the list of results to an analysis page and then impose some conditions on each result. The analysis takes mere seconds, it's the getting the data list that's bogging down the program. I was wondering what is a better, faster way to record these results. I'm fairly new to VBA so I'm unfamiliar with the ways to handle temporary results. I don't need to reference these results later, I just gather them, analyze them and stop the program if they meet a very specific condition.

any ideas?

[AB33]

You may need to assign(Upload) the range in to an array, loop through the array using what ever condition you set up. When all is done, you can copy the adjusted array back in to a range. Normally, looping though an array is much more efficient than looping through a range.