Forum Discussion
Solved
VBA Code Help - Changing Color of Certain text and characters after specified text
So I am partially VBA savvy but this code seems way over my skill level. I am trying to find the text "ETIC-" in any cell and change it blue; the catch is, that I also want any character that follow...
Hi bakerbaker19
Have attached a revised macro (Test2) which I think should work for every case.
Rich
Unfortunately it does not. I am getting an error of "Run-time error '9': Subscript out of range" and it highlights this row "Out.Characters(x, Len(LArray(1))).Font.ColorIndex = 5 Rich99