Hi,



I have a vba that I got from here to look for a word and removed it from text table. I played around with it and this time to look for a certain word and replace/remove it but no use for a VBA dummy like me. Any suggestions? What I am trying to do is:

1. The word "Done" is incomplete on my text table (header section). What I have is "Do" instead of "Done". I need to have a VBA to automatically add "ne" with it.

2. Remove the word "Pass" on text table.

3. The word "Color Mixed" is too long on text table that the next word "Final" truncates.


Thanks so much for your help!

netchie