MrExcel Publishing
Your One Stop for Excel Tips & Solutions

find/replace macro

Posted by Karen on August 16, 2001 7:33 AM

I have two cells with text being automatically pasted into them. I want a macro that performs a find/replace on my entire sheet based on the two cells. One cell being the data found and the other cell being the replacement data. How does this appear in the macro? Thank You for any help you can give.

Posted by Rick on August 18, 2001 8:09 AM

I believe that you could create a Macro that would contain a IF Statement formula that would cover the range of all the cells in the spreadsheet, telling it that if the criteria in the cell is meant then replace it with the required data. I hope this is what you are wanting to do. Email me at if you want to further discuss this.