Stop looping

hi forum

i have this code that i'm trying to reuse .

this code before would find me a string in 2 sheets and return to a new range, but it also delete the contents of the cell once found.

I want to change this code in order to find a string and paste them into a new range but i don't know how to because there is a line that says loop until R is nothing .

i have change some parts of the original code but this part i don't know how to do it .

Please Login or Register  to view this content.

Originally Posted by patel45

Please Login or Register  to view this content.

this solution stop looping.

but the code will only find one string i want the code be able to find several instances and copy them to the new range.

like this find first copy destination (new range) then find next and repeat until all are found.

after sleep on it finally got what i wanted

Please Login or Register  to view this content.