VBA Bold Text

[agtjones]

Hi All,

Is there a way using VBA to make part of a text string within a cell go bold? i.e. I want to me this text bold only

[Bob Phillips]

An example


testvalue = "text"
With ActiveCell

.Characters(InStr(.Value, testvalue), Len(testvalue)).Font.Bold = True
End With