Thread
:
how to italic the word with vba
View Single Post
02-03-2014, 07:09 PM
tomlam
Windows 7 64bit
Office 2007
Advanced Beginner
Join Date: Oct 2012
Posts: 33
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
tomlam
View Public Profile
Find all posts by tomlam