I have 2 cells on a worksheet.
One contains text I want to search for and the other contains the text I want to replace it with.
I have a macro which does it all but I need the macro to access the above 2 cells each time as they will always be different. Is there a simple VB command for this please?
Bookmarks