Any object which has the characters property and supports Rich Text
Formatting. For example, the text of cell comments, text in the textbox
from the drawing toolbar.

--
Regards,
Tom Ogilvy

wrote in message
...
You, the man!

Can I apply a format to any string or just to the
contents of a range???

Thanks


-----Original Message-----
Characters Property Example

This example formats the third character in cell A1 on
Sheet1 as bold.

With Worksheets("Sheet1").Range("A1")
.Value = "abcdefg"
.Characters(3, 1).Font.Bold = True
End With
--

John

johnf202 at hotmail dot com


wrote in message
...
I never did post a question with this statement - is
there a way to format a part of a cell?



-----Original Message-----
I thought I could use html tags within a cell to bold
cetain words etc. such as My name is <BDan<b and I
want to be bold but it does not work.
.



.