Repetitive Addition and Copy Paste VBA

Hi guys,

I need help with this simple VBA task that I don't know how to approach as of this moment.
In the table shown below, 0.0001 is in cell A1.
1.02% in cell A2 has a formula: =0.01+A1
So what the VBA should do is that:

1. write 0.0001 in cell A1
2. copy and paste as values whatever the result is in cell A2 to one cell below C2, where the word "List" currently occupies it.
3. then go back to step one, but this time instead of 0.0001, it will now put 0.0002 (increments of 0.0001)
4. then repeat step two, but this time it will be two cells below C2 since the previous step has pasted the previous result one cell below C2.
5. then so on until the written value in cell A1 is 0.90000.

0.0001		Results
1.01%		List

Thank you so much.

Please Login or Register  to view this content.

Hi sintek, thank you. It's perfect!