ActiveCell.Characters(15,6).Font.Bold = True

worked for me.

--
Regards,
Tom Ogilvy



"Brad" wrote in message
...
Thanks for taking the time to read my question.

It is possible to apply the Bold font setting to an entire cell. It is
also
possible to apply the Bold setting to portions of text in a cell and leave
the remaining portions unbolded (if that's a word...).

How can you do that in VBA?

Ex:

Activecell.value = "The Number Is 550055"

I want "550055" to be bold, and the rest not bold.

How do I do this in VBA?

Thanks,

Brad