When you edit a cell in excel you can select any text you wish (Not th
entire cell) and make it bold. How do you do this in vb?

For example:

I am *so* great

Here, only the word "so" is in bold.

Any ideas?

Cheer

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

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

Cheers gitcypher,

That seams to be exactly what i'm after, haven't tried it yet but wil
have ago shortly.

Thanks agai

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