Range("*yourcellname*").Characters(-position of the first character i
the string-, -length or characters to select *includin
spaces*-).Font.Bold = True

for example
You have a cell (A1) named 'TestCell'. The words "Happy New Year" ar
inside.

Range("TestCell").Characters(7,3).Font.Bold = true

Would produce,

Happy *New* Year

Search for 'Characters Object' in VBA help, and it'll tell you al
about it.

-Gitcyphe

--
Message posted from http://www.ExcelForum.com