How to remain initial cell value after loop

[alee001]

I want to use each cells on column for loop within range in order to find out each result but how to remain/re-write the initial cell value before/after loop? thank

[arlu1201]

You can use 2 variables - 1 for before loop and 1 after loop. Before starting the loop, assign the value to the 1st variable and once the loop runs, assign the value to the 2nd variable.

If you still need help, attach your sample file and the code you are using.

[alee001]

You can use 2 variables - 1 for before loop and 1 after loop. Before starting the loop, assign the value to the 1st variable and once the loop runs, assign the value to the 2nd variable.

If you still need help, attach your sample file and the code you are using.

Thank for your tip, i use a stupid method(???) with copy & paste to recover inital value after/before loop, could you give me any suggestion as following code?

Please Login or Register  to view this content.

[arlu1201]

Try this

Please Login or Register  to view this content.

[alee001]

It work!...Thanks for your help.