Excel VBA Loop Question

[carcanfloat]

Hi all,
Trying to do the following steps in order.
1. write formula(A) into A1
2. copy A1 and paste value into A1
3. move to A2
4. write formula(A) into A2
5. copy A2 and paste value into A2
6. move to A3... and so on until A100

Thanks