Maco - Copy, Paste, Find, and Replace

[gjohn282]

Hi,

I need help creating a macro that will do the following:

1) Copy Cell A1
2) Perform the Find and Replace function, in which the Replace value is the copied value from cell A1.

Side Note: The value I want to "Find" would be a static value, so I would just build that into my macro, but the "Replace" value changes.

Here's what I have so far, but it's not working....

Please Login or Register  to view this content.

Thanks!

[p24leclerc]

try this, it should work.

Please Login or Register  to view this content.

Pierre

[gjohn282]

Thank you so much! This worked perfectly!