Find and replace to specific cell content

Hi gentlemen,

I would like to get advice from you.

I would like to find in column "J" all letters "x" and replace this "x" by string in cell R7

Macro:

Please Login or Register  to view this content.

---

How to wrote replacement by cell ? Actually all x are replaced to R7, but not the cell R7, but name "R7"

Hi, xbr088,

please wrap up your code in code-tags for better readability.

Please Login or Register  to view this content.

You would need to qualify the Range like stated above if it´s located on the same sheet or fully qualify the sheet and the range if located on another sheet.

Ciao,
Holger