Store data and put them on a new sheet?

[doctortt]

Gurus. I need some help.

I already have codes to perform some calculations in a loop. How do I store and show the data of each loop onto a new sheet???

[doctortt]

I believe that I have to store the data into an array. But how do you do it? Can someone shed some lights.

I want VBA to store the value of a formula into an array, and then put it on a new sheet.

[BrianMH]

is the number of elements fixed?