Formatting part of Cell

[Voskre]

Hello to everybody.

I have a set of cells filled with different texts.
I need to bold formatting a word (not always the same) of each text.
Any idea either how to do that or where to find something done?

Thanks for any help.

V.

 

[Ron de Bruin]

Try this

Range("A1").Value = "Hi There"
Range("A1").Characters(Start:=4, Length:=5).Font.Bold = True

 

[Voskre]

It works.

Thanks

V.

Try this

Range("A1").Value = "Hi There"
Range("A1").Characters(Start:=4, Length:=5).Font.Bold = True

 

[Ron de Bruin]

It works.

I know <vbg>