Find and copy into cell

[JSpark658]

Hello. I have this piece of code that I previously got from Phil_V. It works great for its intended use, but now I am trying to alter it. What I would like it to do is find a particular word “Test” and copy it to the cell to the left on the same row. I tried setting ranges and using the copy method, but everything in the range got deleted when the word was pasted. I just want the one word to be copied. Anyone thoughts? Thanks.

Please Login or Register  to view this content.

[roli001]

This should help:

Please Login or Register  to view this content.

[JSpark658]

I pasted that into a module, but nothing happened. Is there something else I should do with it? Thanks.