Replace text entries using code throughout the workbook.

[markDuffy]

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

[ragulduy]

You can use the find and replace button from within excel (turn on the macro recorder and see what code you get...) should be something like:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[markDuffy]

Hi Guys
I had tried the first suggestion using the replace whilst the macro was running. What happened was the macro recorded the actual entry and this will vary. So I, at least could go that route.

John your formula must have worked for you or you would not have uploaded it. I have put it in my workbook but I don't know how to run it. I have attempted to run it from View and to step into it. Stepping into it seems fine in that it goes through the steps but it makes not alteration on screen. Your code refers to other sheets so i created a second sheet and then ran it. hey Presto ran beautifully.

This is not a big job for me or so i thought I have been "altering" a work book using the replace facility for each entry all morning. Because the process is tedious I become a little lazy about replacing the entries. So thanks again. Its a really nifty code.

Mark

[JOHN H. DAVIS]

You're welcome. Glad to help out, and thanks for the feeback and the reps.