Change font style of part of my macro

[Sethomas5]

Hello and thank you in advance!! This forum has been so helpful to me these past few weeks. I'm learning a lot too.
I'm running Excel 2013 on Windows 7.

This is the piece of code I am working with:

.Bookmarks("Oral_Class1").Range.Text = ws.Range("I2").Value & "/" & [COLOR="#FF0000"]ws.Range("G2").Value[/COLOR]

I would like to have the piece in RED be italicized in my word document.

Please let me know if you need clarification.

 

[Sethomas5]

It looks like the Word object model has Range as a member of the Bookmark class, so try this for each of your bookmark references:

.Bookmarks("Writing_Class1").Range.Font.Italic=true

Would that make both Range ("I2") and Range ("G2") italic in my word document?
I need only the second range ("G2") to be italic...

 

[bfreescott]

The ranges I2 and G2 don't exist in your Word document. Only the Bookmark does. Therefore, you are italicizing the bookmark. The format of the Excel ranges is not relevant.

 

[Sethomas5]

The ranges I2 and G2 don't exist in your Word document. Only the Bookmark does. Therefore, you are italicizing the bookmark. The format of the Excel ranges is not relevant.

That makes sense. I guess I am trying to do something that cannot be done. I wanted the value retrieved from I2 to keep regular font and the value from G2 to be italicized when put in the word document...
OH WELL.

Thank you for your help.

 

[RoryA]

Did you try this?