Replace based on a value in a cell

[stuartb]

I want to have a find and replace function that finds and replaces values on a sheet based a cell containing the find value and a cell containing the replace value.

At the moment i have

Please Login or Register  to view this content.

which will find C[2] and replace it with C[3] but i want both of the values to be entered into two cells on the work sheet rather than having to amend the code each time?

[VBA Noob]

Please read forum rules below and then wrap your code

VBA Noob