See my answer for insights into your problem.
You can not achieve this with a formula.

--
Regards,
Tom Ogilvy


"Robs" wrote in message
...
Leith:

I tried what you said, it does not work. so I tried to simplfy what I
was doing and build from there. So I made cell (B1) have the word TEST in
it. Then in cell A11, I put the following formula:
=Range("B1").Characters(1,Len(B1)).Font.Bold = true. I get the error
message: Your formula contains an error.

I have to admit, I am not an excel programmer. I do most of my
programming in C#.

Thanks for any help that you have.

Robs

"Leith Ross" wrote:


Hello Robs,

Here is an example using cell "A1"...

AmountDue = "$1.75"
A1 = "Your library book is OVERDUE 01/22/06" & AmoutDue
Range("A1").Characters(22, 16 + Len(AmountDue)).Font.Bold = True

The Characters property has 2 arguments, the starting character
position and the number of characters. Since the amount can vary in
length, I placed it in a separate formatted string.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=505843