In column A is text. Part of the text, say, A2 = aa, bb = A3, A4 = cc, 5 = dd etc. Some of them are repeated several times.
In another text B2 I say PION. I would like VBA code to replace aa, cc and dd with PION. There are about 5000 rows. Not to
write in code all those words (w = array (aa, cc, dd etc ...)) I want to use something like Range ("D2: D40") - here are the
words that I want to replace . And in E2 is word to replace
Can anyone help me?