Do Find & Replace multiple times using data in Col B for find & data in Col C for replace

Try this

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.

Thought I had replied but don't see it - Excuse if sent 2 times -
Did not work, but could be because of the placement of my data.
What columns is this sent to work with?
I have the date that is to be manipulated in A, the "Find This" in B and the "Replace With" in C.
Top row of all is 8.
Thanks
Bill

You would need to set N = 8 in the first row of code. If you still have problems, I suggest posting a copy of the actual data as there may be some important detail that your description missed.

Hi -

Give a try using FIND method;

Please Login or Register  to view this content.

Regards,
event

It worked - Thanks
BUT - I try to learn from you guys so I would like a tad bit more help here - PLEASE!
If I wanted to use this other times - with other configurations - what is it that is now Column A, what is it that is now column B and what is it that is now column C?
I tried to play with your solution by putting the data that is now in B & C into C & D and then changed your macro - changing each b to c and each c to d, but it did not run.
Thanks

Hi -

Your problem has been solve now based on your feedback, and if you have read the rules, you know what's next;

Anyway, to give you some idea, I have commented the codes;

Please Login or Register  to view this content.

Regards,
event