Hi Guys
Does anyone know how I could have some code to replace various Text entries, varying number but about 20 throughout a workbook in the very same way the find and replace button works. The code would be on my machine so that when I circulated the workbook only the replacement text would be visible. And then of course to be able to use this to revert later.
Knowing the power of Excel I am assuming this is possible. I have no idea at all where to start. Have popped up an excel workbook - only one sheet but you get the idea.
Here's hoping.
Mark
Bookmarks