PDA

View Full Version : Solved: Excel 2003/07 - I need to Bold two portion's of a string?



frank_m
11-04-2010, 02:18 AM
I have a String Value in Cell A18 "Po Line 2 item has 3 Line /s"
How might I bold only the "Po Line 2" and "has 3" part's of that string?

Thanks in advance.

Bob Phillips
11-04-2010, 02:32 AM
With ActiveCell

.Characters(1, 9).Font.Bold = True
.Characters(16, 5).Font.Bold = True
End With

frank_m
11-04-2010, 02:36 AM
Thanks xld

Works like a champ :thumb