Writing vba ouput into excel file

[110887]

hi, I am running a for loop 100 times. each loop giving an output.
and I wish to print all those outputs into an excel file. I tried using

Worksheet("sheet1").Range(A1:A101) = VBA.abs(value)

But the trouble is that it prints the same value a 100 times for every loop, with every loop output over writing the previous one's output.
Meaning the output I can see is of the 100th loop printed in a 100 cells(A1:A101). Where as I want all the 100 (different) loop outputs to be printed.

Any help would be greatly appreciated.
Thanks

[NeoPa]

It would make more sense to include the code for the loop in the question, but I will have to assume you have variables available that reflect the iteration through the loop (I'll use intX.) and the value to be assigned (I'll use intVal as value would not be a clever choice).

Worksheet("sheet1").Range("A" & intX) = intVal