View Single Post
 
Old 02-03-2014, 07:09 PM
tomlam tomlam is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Oct 2012
Posts: 33
tomlam is on a distinguished road
Default

oh the answer is as follows. the problems solved

Sub testz()
For i = 1 To 100
pos = InStr(Range("e"&a).Value, "peter")

With Range("e"&a).Characters(Start:=pos, Length:=5).Font
.FontStyle = "Italic"

End With
Next a
End Sub
Reply With Quote