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
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?Please Login or Register to view this content.
Bookmarks