Search and replace in multiple columns

[ajm1949]

Hello
What I need to do is replace a bullet symbol in multiple columns with text from row 2 of that column (Bullets in column c get replaced with text from c2)and then re-format that column to Arial 10 pt font.
I can do it with this macro one column at a time but would like to do it all in one step. If possible I would also like to be able to loop though all worksheets (approx 19) and do the same on each sheet.

Please Login or Register  to view this content.

I hope this is clear enough and thanks in advance for any help

Cheers

Alan

[arlu1201]

Hi Alan,

Welcome to the forum.

Since you are new to the forum, i have put code tags for you. In future, please put your code within code tags. It makes the code easier to read and people will help you faster.

[ajm1949]

Thank you Arlette
I will do that in future posts

Alan

[JBeaucaire]

Please Login or Register  to view this content.

[ajm1949]

Hello Jbeaucaire
Thanks for the code. The problem I have is that in column G bullet symbols are replaced with text from G2, bullets in Column H are replaced with text for H2 and so on
Your sample code will replace all bullets with text from G2

Cheers

Alan

[JBeaucaire]

More like this then?

Please Login or Register  to view this content.

With your next change/addition, make a guess at some code tweaks and show me what you tried if you can't get it working.

[ajm1949]

Many thanks for the code. It did the job perfectly

Cheers

Alan