Find and Replace Text in Formula on a given worksheet in an excel workbook using VBA

[welchs101]

Hi, I have an excel worksheet in a given workbook and i need to replace several text strings with new text strings which i have now defined as "named ranges".

So i have in the formulas something like this................ "texttoreplace"...........

basically text with quoest around it.

I want to replace this text with DefnName1 where DefnName1 = "texttoreplace"

I did record a macro and here is what i got

Please Login or Register  to view this content.

But i am not sure how to really incorporate this into my code. I have a list/array of text i wish to replace and an array / list of text i wish to insert in its place.

What i was hoping for is to search a given worksheet and then replace the text with my new defnd name.

Any ideas?

I have like over 200 of these to do this is why i am looking at a macro instead of doing it manually.

[JBeaucaire]

If on sheet2 you had a two column list... column A the strings to FIND and column B the strings to REPLACE, then this macro would use those string-pairs to do a FIND/REPLACE on sheet1:

Please Login or Register  to view this content.

More here:

Mass Replace