Ethen5155
03-24-2018, 07:35 AM
Hi all,
i tried to do a macro that can color Camel Cases words like (UnderGround, FedEx) through all excel cells but i failed becasue i don't want to include text with space between the two words as shown below:
21907
Simply, i want to look for all words that have two upper cases characters without space between them and color it like (MyComputer or AppleIphone)
and to skip words like (My Computer or Apple Iphone) because there is a space between the two words
is it possible to do??
thanks in advance
Ethen
Cross-Posting: https://www.excelforum.com/excel-programming-vba-macros/1225319-color-uppercase-words.html#post4870363
i tried to do a macro that can color Camel Cases words like (UnderGround, FedEx) through all excel cells but i failed becasue i don't want to include text with space between the two words as shown below:
21907
Simply, i want to look for all words that have two upper cases characters without space between them and color it like (MyComputer or AppleIphone)
and to skip words like (My Computer or Apple Iphone) because there is a space between the two words
is it possible to do??
thanks in advance
Ethen
Cross-Posting: https://www.excelforum.com/excel-programming-vba-macros/1225319-color-uppercase-words.html#post4870363