Chris,

Select the part of the text you want to change in the preview pane (I
think that is what it is called - the window at the top of your screen
that displays the contents of your cell). Just select it with your
mouse & change what you want. Very handy for bold, new colors, etc.

Don S

On Tue, 1 Mar 2005 07:43:06 -0800, "Chris"
wrote:

I am trying to change the font of only part of a cell. After locating text
in a cell through find, I would like to take part of that cell and change the
font. The text I would like to change is at the same but the start location
is different. I was planning on after using the find fucnntion in VBA to use
the following function to change part of the cells font
With ActiveCell.Characters(Start:=X, Length:=4).Font
The only problem is that I need to figure out how to define X. Any ideas on
how to locate the text "(u" in a cell and record its starting position?
Thanks.