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
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
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.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
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.
Try this![]()
Please Login or Register to view this content.
It work!...Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks