if letter change font also change

gsrikanth · #1 05-15-2012, 03:03 AM

Quote:

Originally Posted by gsrikanth

1) §´ýÖçµ

2) §Ó´ýÖçµ

i have two words in the column in one cell either first come or the second word

if first word come change that cell font to times new roman
if second word come change to arial font how?

only we have find "Ó" letter in cell change the font

=if(find("Ó",a1,1)>0,With ActiveCell.Characters(Start:=1, Length:=end).Font
.Name = "Times new roman"
End With, (else),With ActiveCell.Characters(Start:=1, Length:=end).Font
.Name = "arial")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Make Font Dropdown Change All Styles' Font	trevorhiller	Word	1	04-14-2012 02:14 AM
How to change font style in wordart....	licsivaraman	Drawing and Graphics	2	01-24-2011 11:27 PM
Change Default Font Word	datuk.ahmad	Word	3	03-09-2010 04:47 PM
Change font across company	Dill	Excel	1	11-04-2009 08:21 PM
How do I change the default font?	mrylanxus	Office	1	05-31-2009 01:52 AM